Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd macro performance. Explanation? joeu2004 Excel Programming 5 December 26th 07 03:55 PM
Cursor placement without Macro/VBA dwiba New Users to Excel 3 December 20th 07 01:27 PM
Putting Cursor in Cell A1 of each Worksheet, then ending cursor on smalest sheet name according to VBA Editor Matt[_40_] Excel Programming 1 May 14th 07 09:21 AM
macro to move cursor Bob S[_2_] Excel Programming 4 January 15th 04 03:36 PM
Cursor Movement in Macro Ron de Bruin Excel Programming 0 August 5th 03 04:43 PM


All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"