Linking Shapes to Cells
You can show the contents of a cell inside a shape. Whether it be the caption of a commandbutton from the Forms toolbar or a rectangle from the Drawing toolbar, a simple formula will do the job. Just select the shape and type the formula in the formula bar.
This example shows both a rectangle and a commandbutton.
Zoltan Till:
Hi Dick,
This solution works for the wordart text too.
Best Regards,
20 September 2004, 10:40 amZoltan Till from Hungary
charlie:
Check out what happens with the font colour when you link a button to a cell. Change the font colour once from standard, and the font on the button changes. Change it again, and this time nothing happens on the button! Excel just keeps you guessing doesn’t it!
21 September 2004, 3:26 amChristopher:
I had call to use this today - interestingly, you can’t place a formula in there.
Just, as you say, the contents of a cell (which is where the formula now lives!)
cheers,
30 September 2004, 6:01 pmChristopher
Tramadol:
The secret of health for both mind and body is not to mourn for the past, worry about the future, or anticipate troubles but to live in the present moment wisely and earnestly. Tramadol online
26 December 2004, 6:07 pmS. Kirby:
I am trying to change a picture in an image field on a form based on a selection from a combo box. Is there any way to set the picture property from pictures stored within Excel? I don’t want to store the pictures externally.
3 July 2007, 3:01 pm