Macro Screen tip

[John]

Hi, Anyone know whether you can add a screen tip to a text box that has a
Macro assigned to it? Somewhat similar to the screen tip displayed when you
hover the cursor over a hyperlink.

I am using Excel 2000.

Thanks

 

[Mike Rogers]

John

Place your text box, assign your macro, select the textbox and move to the
border. With your curser over this border right click and hyperlink, when
the window appears select the "Place in this Document" choice under "Link
to". Enter your screen tip, select your sheet (this activates the "OK" at the
bottom of the window) and excel will automatically enter "A1" into the "Type
the cell reference:", I deleted that reference, and oked out. You now have a
screen tip that is shown when you hover over the text box. When I did this I
could then place the text box anywhere on my worksheet and the screen tip
would follow.

I hope this helps you.

Mike Rogers