Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
Is it possible to remind the explanation of macro, that is assigned to a shape; when the cursor is on the shape? Thanks for help |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can use the ScreenTip of a hyperlink.
Do not assign the macro to the shape directly. Instead, assign a hyperlink to the shape to take you to some remote cell, say Z100. Put your text in the hyperlink's ScreenTip. Then use the Worksheet_SelectionChange event macro to call your macro when Z100 is selected. What should happen: 1. the user hovers the cursor over the shape 2. the user sees the hyperlink text message 3. the user clicks the shape 4. the cursor jumps to Z100 5. the event macro detects that Z100 has been selected 6. the event macro calls your macro -- Gary''s Student - gsnu200823 "nerohnze" wrote: Hello Is it possible to remind the explanation of macro, that is assigned to a shape; when the cursor is on the shape? Thanks for help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Odd macro performance. Explanation? | Excel Programming | |||
Cursor placement without Macro/VBA | New Users to Excel | |||
Putting Cursor in Cell A1 of each Worksheet, then ending cursor on smalest sheet name according to VBA Editor | Excel Programming | |||
macro to move cursor | Excel Programming | |||
Cursor Movement in Macro | Excel Programming |