PDA

View Full Version : Solved: little code needed


eliW
10-28-2005, 03:28 AM
Hi all,

Just curious to know how this forum is,
Can you help to solve this?

http://www.mrexcel.com/board2/viewtopic.php?t=176297

Thanks,

Eli
Bob Phillips
10-28-2005, 04:01 AM
I would have another cell on the worksheet that averages those cells =AVERAGE(A2:C2).

Then I would add a textbox not label. You could have a sunken special effect and grey background if you wanted it to look like a label. Then set the textbox's ControlSource property to that cell.

Result: automatically keeping aligned.

It is either that or a worksheet change event on thjose 3 cells.
eliW
10-28-2005, 04:42 AM
thank you
this forum works great
Eli
Bob Phillips
10-29-2005, 07:50 AM
thank you
this forum works great
Eli

Sorry, I didn't see this yesterday.

Can you tell us, did you find this response more useful than anything at MrExcel or not?
Norie
10-29-2005, 08:08 AM
Eli

In the link, as far as I can see, the problem was solved.
Bob Phillips
10-29-2005, 10:33 AM
Eli

In the link, as far as I can see, the problem was solved.

But that is irrelevant to my question.
Norie
10-29-2005, 11:15 AM
But that is irrelevant to my question.
xld

My post was directed to Eli. :)
Bob Phillips
10-29-2005, 11:32 AM
xld

My post was directed to Eli. :)

Sorry, misunderstood.
Zack Barresse
10-29-2005, 04:47 PM
Eli

In the link, as far as I can see, the problem was solved.
Maybe you should check the times. At the time of this post, the OP had not gotten back whether the solution worked for them or not. xld did, after all, provide another (IMHO superior) solution to Alan's. Both work great in their own respects, but it's always nice to see different ways to "skin the cat". :yes