Macro for the F1 "help text" key inside a form field

[Shari]

I added help text to a form field and want it to pop up when you tab to the
field. However, when I go to record the macro, it records the F1 Microsoft
Help screen. If I lock the form, I get the F1 help text, but I can't record
a macro when the form is locked. Any suggestions?

 

[Charles Kenyon]

You can add help at the F1 key and in the status bar using the properties
dialog for a field. Otherwise, you could pop up a messagebox with your text
via an onEntry macro. Not sure why you want help to popup when you tab out
of a field, but you could have an on-exit macro instead. All of this is set
in the field's properties while the form is unprotected.

What you are talking about is what Word calls an "online form." For more
about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
Chapman's series of articles. You may also want to look at
http://www.word.mvps.org/FAQs/TblsFldsFms/LinesInForms.htm.

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[Shari]

Thanks, but the real problem is with the F1 key. When I record the macro
(with the form unlocked) and press F1, it launches MS Word On-line Help. I
want it to launch the "help text" I entered in the form field. The only way
to get to this help text is to lock the form. If I do that, I can't record a
macro. Hope I'm explaining it right -- any suggestions? Thanks.

 

[Charles Kenyon]

I've crossed-posted this to the vba.beginners newsgroup.

This is an instance where you can't record a macro, you'll have to write it
or modify what you record.
http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm

What, exactly do you want your macro to do?
Why? (Important because there may be easier ways to accomplish what you
want.)

Which version of Word?

A simple on-entry macro to display something:

Sub OnEntryMacro1()
MsgBox _
Prompt:="This is the help text.", _
Title:="Help for this field."
End Sub

Note, this has nothing to do with the help text you put into the field. The
text is in the macro. You could create one that would pull out the field's
help text, instead. But I don't know how.

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.