If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Run macro on mouse over -Excel

Peter B · 2009-01-27 11:52:30

Anyone know is it possible to run a macro in excel when the mouse cursor hovers over an object (rectangle)? I have each object performing a macro when clicked but I want them to highlight certain cells when hovered over with the cursor. I couldn't find any answers on google.

Options

27-01-2009 12:52pm

#1

Peter B

Registered Users Posts: 1,086 ✭✭✭

Join Date: April 2000

Posts: 806

Anyone know is it possible to run a macro in excel when the mouse cursor hovers over an object (rectangle)?

I have each object performing a macro when clicked but I want them to highlight certain cells when hovered over with the cursor. I couldn't find any answers on google.

0

Comments

Options
#2 27-01-2009 1:10pm
kayos

Registered Users Posts: 2,494 ✭✭✭

Join Date: April 1999

Posts: 2356

If you look at the events available on the object you should see some mouse events. The mousemove is the most likely canidate for what you want. But be careful not to go calling the macro every single time the mouse moves over the control without first leaving it.

0