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.

27-01-2009 12:52PM

#1

Peter B

Registered Users, Registered Users 2 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

#2 27-01-2009 01:10PM

kayos

Registered Users, Registered Users 2 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