Formula to open an Autoshape

M

meeradhruve

Hi guys...Is there a way I can open up a textbox/Autoshape using a
formula? I want the cells to check for a condition and if it is
satisfied I want to print a value in a textbox or autoshape. I really
appreciate your help!

Thanks
Meera
 
D

Don Guillett

Not with a formula. A formula can only return a value. Give detailed needs
for a macro solution
 
S

Stephen Bye

If you use a Text Box object from the Control Toolbox toolbar, you can set
its "Linked cell" property so that the text that is displayed is retrieved
dynamically from a worksheet cell. You can the put a formula in that cell
that checks the condition and results in the text that you want displayed.
 
M

meeradhruve

Thanks guys..I really appreciate your help. I did link the cell to the
reflect in the text box. But the cell that I want the text box toappear
near may change and I wanted the text box to move accordingly rather
than do it manually.

I don;t knowanything about the macros. Would I be able to do this with
macros?

Thanks,
Meera
 
Top