Creating message boxes

G

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.
 
C

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,
--

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

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
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.
 
G

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top