Have shapes react to events in Excel 2010

[Frank]

Hello,

can VBA (possibly by way of classes) make shapes respond to events,
such as Click or MouseMove ? If so, how ? Thank you in advance.

Regards,

H.G. Lamy

 

[Don Guillett]

Hello,

can VBA (possibly by way of classes) make shapes respond to events,
such as Click or MouseMove ? If so, how ? Thank you in advance.

Regards,

H.G. Lamy

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[Clif McIrvin]

Hello,

can VBA (possibly by way of classes) make shapes respond to events,
such as Click or MouseMove ? If so, how ? Thank you in advance.

Check out the Help text for the Shape.OnAction property. That gives you
click -- I don't know about mouseover.

 

[Peter T]

Check out the Help text for the Shape.OnAction property. That gives you
click -- I don't know about mouseover.

No Shape events are exposed except OnAction (assign a macro and can
effectively get mouse click) and Hyperlink (not likely to be of much help).

Regards,
Peter T