Have shapes react to events in Excel 2010

  • Thread starter Thread starter Frank
  • Start date Start date
F

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
 
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
Click to expand...
"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."
 
Frank said:
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.
Click to expand...


Check out the Help text for the Shape.OnAction property. That gives you
click -- I don't know about mouseover.
 
Clif McIrvin said:
Check out the Help text for the Shape.OnAction property. That gives you
click -- I don't know about mouseover.
Click to expand...

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
 
Back
Top