No! Form fields provide three forms of help.
1. Help text that is printed in the status bar
2. Help text thatresponds to the F1 key
3. Help text that is activated by a macro either automatic or run on entry
to a form field
or a combination of all three.
For the first two check the field properties
For the last you could use code such as
Sub AutoNew()
Dim sMsg As String
Dim sVer As Integer
sMsg = "Refer to status line at bottom of screen for field entry details" _
& vbCr & "Use the tab key to move between fields"
sVer = Application.version
If sVer < 12 Then
Assistant.On = True
Set Balloon = Assistant.NewBalloon
With Balloon
.Text = sMsg
.Button = msoButtonSetOK
.Animation = msoAnimationBeginSpeaking
.Show
End With
Else
MsgBox sMsg, vbInformation, "User Information"
End If
End Sub
http://www.gmayor.com/installing_macro.htm
in the form *template* to draw users attention to the help you wish to
provide. This does of course entail distributing the form as a template.
Issuing *documents* with macros creates a whole new set of problems
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site
www.gmayor.com
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
