How do I pass control to VBA without mouse click

  • Thread starter Thread starter Gilgamesh
  • Start date Start date
G

Gilgamesh

I have a button in a presentation (this can be changed if need be) and I
want control to pass to a VBA macro when the mouse passes over the button
but before the mouse is clicked. Is there any way I can do this?
I thought of the GotFocus event for the button but this requires it to be
clicked first.

Thanks
 
Austin said:
Select your button and in the VBA interface select "MouseOver" instead of
On Clinck.
Click to expand...

Unfortunately there is no MouseOver in the VBA interface (at least in 2007,
I haven't tried 2003).
I never tried to use OnClick because its obvious that wouldn't work, I tried
OnFocus but that also requied a click.
 
You must have a control button, not a regular Auto Shape button. You can
set the Action Settings for an AutoShape button (or any other regular
shape) to activate either on click or on mouse over. I don't believe
there are mouse over options for control buttons.
--David
 
Steve Rindsberg said:
Sounds like you have an ActiveX button.

Instead, draw a regular shape (it can be one of PPT's action button
autoshapes or pretty much anything else).

Assign it a mouseover action setting of Run Macro and pick the macro you
want to run.

MsgBox "Bingo!"
Click to expand...

This works.
Thank You
 
Back
Top