PC Review


Reply
Thread Tools Rate Thread

a brief explanation of macro, when the cursor is over...

 
 
nerohnze
Guest
Posts: n/a
 
      2nd Jan 2009
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 With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      2nd Jan 2009
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd macro performance. Explanation? joeu2004 Microsoft Excel Programming 5 26th Dec 2007 03:55 PM
Explanation of Cursor Types, Cursor Locations for Jet and SQL Server BK via AccessMonster.com Microsoft Access Database Table Design 0 28th May 2005 03:52 PM
Erratic Cursor - Please provide better explanation. =?Utf-8?B?TW91c2UgRWF0ZXI=?= Windows XP Hardware 3 11th Jun 2004 03:18 AM
I Beam cursor explanation please John Microsoft Word New Users 3 11th Mar 2004 09:34 PM
macro - tracking cursor position in macro Avelino P. Arabit Microsoft Excel Misc 1 29th Nov 2003 07:07 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:14 PM.