Hi everybody. I have a questions that is killing me

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.

Does this have a solution?

Thank you all

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

Rolo,

I have a similar thing with control tooltips that I do. What I do is when I
do the mousemove and it is over the control, I fire Ontime() method to run a
macro after a set time which removes the tooltip. I would have thought it is
feasible within that macro to check whether the mouse is still over the
control, and if so, don't re-paint, but just fir another OnTime().

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rolo" wrote in message
om...
Hi everybody. I have a questions that is killing me

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.

Does this have a solution?

Thank you all