Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Screen tip
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Screen tip
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 "John" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
CAE macro for green screen updates with Excel data | Excel Discussion (Misc queries) | |||
Editing a simple macro | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro to display full screen automatically | Excel Discussion (Misc queries) |