View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Control Tip Text Question

You can place the controls within a frame and have a multi-line label placed
in your form. Use the mousemove event to display/hide a label for each
control or display/clear a fixed label (for all controls) using the below
code...You can try out the below by placing a textbox within a frame and
placing a multi-line label on your form

Option Explicit
Private Sub Textbox1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Me.Label1.Visible = True
End Sub

Private Sub Frame1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Me.Label1.Visible = False
End Sub


Alternately, review the bleow link by Andy Pope and download a demo on
handling the help and help text.
http://www.andypope.info/vba/whatsthishelp.htm

If this post helps click Yes
---------------
Jacob Skaria


"TotallyConfused" wrote:

I am using "ControlTipText" to identify the objects in my Userform. Is there
a way to wrap text this "ControlTipText"?? If not, is there any other way to
have this informtion for the user? Thank you for any help you can provide.