Creating message boxes

[Greg]

If you are using proteced documents as a form, you could
run on entry macros for each text field.

E.g.,

Sub Inst1()
MsgBox "Put your name in this field"
End Sub

If you don't want to use a protected form, I suppose that
you could use the same macros and fire it with a
macrobutton field in the cell. Users would have to know
to doubleclick the prompt to fire the macro


E.g.,


{MACROBUTTON Inst1 * }

If the instruction was short you could just use the a
shallow Macrobutton field as a place marker for the prompt.

e.g., {MacroButton NoMacro "Type name here" }

-----Original Message-----
I've just created a set of documents that will eventually

be used by a company as their default templates. Ideally
I want to create some 'pop-up' message boxes to instruct
the users on what text to insert in certain cells of
tables when they click on the cell. It would be perfect
if the message could appear automatically when they select
a cell and after they click 'ok' they can continue.

I remember creating a similar message alert in my ICT A

Level but it was in Access and I can't find anything
similar in any of the Office programs.

 

[Charles Kenyon]

What Greg is talking about is what Word calls an "online form." Check this
in help. 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.

Otherwise, consider using a custom dialog box to gather your information.
This is called a userform and there is a great FAQ on them at the MVP FAQ
site.

Hope this helps,

 

[Guest]

Thanks for the tip, I've downloaded all of Dian's
articles to get me through! My boss doesn't want me to
use any macros whatsoever, due to bad experiences in the
past, so it looks like I'm restricted to using hidden
text in a protected form!