View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Activate / Deactivate mouse move event

Hi Rolo,

1) I have a commandbutton painted with color A.

2) I would like that when I move the mouse over it the button get
painted with color B. (This is easily done with "mousemove").

3)But when I move the mouse outside the button I would like to get it
painted with original color A.

The problem with mousemove is that it triggers an event when I move
over the button but it doesn´t come back to original situation when I
leave movng over the button.


If the button is on a worksheet, you could paint a rectangle behind the
button and use the rectangle's mousemove event to change the color of
the button. Otherwise, if it is on a userform, use the mousemove event
of the form itself.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com