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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 11:52am

#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 12: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