forms, macros, & text form fields

[Shirley]

Can a macros button be inserted into a text form field?

What I am trying to do is create a form that is protected where a user can
enter data into the form fields. The form fields would have helpful text
such as "enter motor size here". This text would be overwritten by the
entry, and this text would not print.

I have set up the form, with all the data entry points as text form fields,
and have protected the form. But I can't figure out how to enter the helpful
text without losing the text form fields.

Can anyone HELP! This is driving me crazy!!

 

[Graham Mayor]

Use the help text function associated with the form field property and draw
attention to it with the following macro saved in the form document template

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 toolbar buttons to edit the document"
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
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


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

 

[Shirley]

Thank you for your help, I will give it a try!

 

[Bob W]

What if the user despises the animated paper clip assistant and has it turned
off? The balloon, however, is OK....any way to just make the balloon appear?

 

[Graham Mayor]

Then just use the Else part of the macro ie

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 toolbar buttons to edit the document"
MsgBox sMsg, vbInformation, "User Information"
End Sub


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


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