Formula to open an Autoshape

[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

 

[Don Guillett]

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

 

[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.

 

[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