View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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??