How do I pass control to VBA without mouse click

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
 
G

Gilgamesh

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

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.
 
D

David Marcovitz

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
 
G

Gilgamesh

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!"

This works.
Thank You
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top