Activate Macro When Cursor Goes Over a Shape

[MikeG]

I have a shape called Oval1.

I would like to set things up so that if a user points the cursor over the shape, then a macro will be activated.

I know how to set things up to activate if the user clicks on the shape:

Sub Oval1_Click()
Do my stuff
End Sub

However, in this new case, I do not want them to have to click - just pass over the shape.

Could someone give me the basic macro-form? Is it a macro associated with the worksheet, as opposed to the shape itself?

Thanks,

MikeG

 

[VoG]

This isn't straightforward because shapes do not have a MouseOver event.

Here's one idea http://www.mrexcel.com/forum/showthread.php?t=287653

 

[MikeG]

Thanks Peter - I'll read through.

Mikeg

 

[MikeG]

Actually, if I just wanted to activate the macro when I move over a cell - say C10 - could anyone tell me the relevant code?

Thanks,

MikeG

 

[VoG]

Similar problem - there is no MouseOver code for a cell or range as far as I am aware.

 

[MikeG]

Thanks again Peter. When does "MouseOver" apply?

MikeG

 

[VoG]

Really only on UserForms

 

[Legacy 98055]

The best way I know of is to encapsulate this within a separate component so your workbook is not bogged down by a polling timer. I have one that you are welcome to. Just shoot me a PM if you are interested. It's a simple dll that throws events to your worksheet and passes the object (Range or Shape or OleObject) that the mouse is currently over. You will have to distribute the dll with your workbook.

 

[lenze]

Depending on what you are trying to do with your macro, you might just use a BeforeDoubleClick event. It's really less annoying than a Mouseover or Selection because it takes deliberate action to fire the code.

lenze

 

[Legacy 98055]

Unless he after affects or some other reason that one might use hot tracking. You can do some really cool things with maps for example, using hot tracking over shapes. Charts provide some of this functionality I think though I am not familiar with it.l