Textformat with mouse-over in userform
 

Textformat in a userform can change on mouse-over in Excel:
email1A.Font.Underline = xlUnderlineStyleSingle underlines the e-mailadress.
But: email1A.Font.Underline = xlUnderlineStyleNone does not bring back the
original format. Any suggestions??

Textformat with mouse-over in userform
 

Hi

The available controls doesn not have a "mouse_out" / "mouse_leaving" event,
so highlighting with "mouse_over" can get quite complicated. I believe the
common solutions are to either make a timer check wether the mouse is still
there, or call the necessary cleanup code from all the other controls'
mouse_move events.

Otherwise, make sure to put Repaint in code that deals with visual changes
of the form.

HTH. Best wishes Harald

"Gert-Jan" skrev i melding
...
Textformat in a userform can change on mouse-over in Excel:
email1A.Font.Underline = xlUnderlineStyleSingle underlines the
e-mailadress.
But: email1A.Font.Underline = xlUnderlineStyleNone does not bring back the
original format. Any suggestions??