ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   mouse move event (https://www.excelbanter.com/excel-programming/337909-mouse-move-event.html)

David

mouse move event
 
Greetings and TIA for your time
I need your advice on the feasibility of an idea:
I'm using worksheet drawing objects as 'buttons" to run macros. I would like
to temporarily change the fill colours of the "buttons" when the mouse moves
over them before the mouse click to activate the macro. I thought that maybe
I could position an active X control behind each "button" and trigger a maro
to change button colours with the mouse move event. The control would idealy
be without any fill or lines. Also, I would need to identify the worksheet
shape object ("button") to re-color within the event handling procedure.
Maybe I colud group the control and shape object and then identify the shape
object from this association (maybe a .parent type thing)
Any advice will be greatly appreciated

--
David


All times are GMT +1. The time now is 11:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com