Hidden directions in forms?

[ModingBlaine]

I am creating a form where there are three subjects that users will write a
summary in the paragraph form below it. Our idea is to have directions for
each subject appear (or pop up) as the user drags his/her curser over the
field. Sort of like how a comment might work in Excel. We want a clean look
to the form without a lot of clutter, but want standarization and we'd like
to have everyone have very clear directions.

Is this possible, or do you have a better suggestion?

Thanks

 

[Graham Mayor]

If this is a protected form, you could use on entry macros to pop up a
message, e.g.

or use the help text property of the field.

or use the following macro to pop up on creating a new document to address
the user's attention to the latter. The macro uses either the help assistant
or a message box to display the message.

Sub AutoNew()
Dim sMsg As String
Dim sVer As Integer
sMsg = "Refer to status line at bottom of screen for field entry details"
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
End If
End Sub

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[ModingBlaine]

Thank you! Instead of using the status bar I just replaced "Refer to status
line at bottom of screen for field entry details", in the code, with the
directions I wanted.

 

[Graham Mayor]

OK, but if you add the help text to the fields the original macro simply
draws attention to it. Whatever works for you

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>