ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   a brief explanation of macro, when the cursor is over... (https://www.excelbanter.com/excel-programming/421895-brief-explanation-macro-when-cursor-over.html)

nerohnze

a brief explanation of macro, when the cursor is over...
 
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

Gary''s Student

a brief explanation of macro, when the cursor is over...
 
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



All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com