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