How to create a msgbox?

M

Method

Hi! My first post here and I'm glad I found this place. I have a form
I am working on, and I would like to make it so that when a user clicks
or tabs onto a certain field a message box will pop up telling them
something.

Say for example the user clicks on the phone number field. I want a
message box to pop up and tell them the not to forget the area code.

I was also wondering if there was a way to add dashes in a field.
For example, when a user goes the the Social Security Number field,
they type the first three numbers and a dash appears, they type the
second three numbers and another dash appears?

The first question is the most important one. Thanks in advance!

-Rick
 
M

Method

Do I have to program the message box in using macros? Is there away for
my users to view some sort of pop up box even if their macro security
settings are on "High" and therefore disable my macros?
 
M

Method

Wow, this forum is awesome. Thanks for ignoring me. I'll be sure to
come here a lot.
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

What sort of form are you talking about?

If it's a protected document using formfields, you can have a macro run on
entry to the formfield in question that contains the following Code

MsgBox "Don't forget the area code"

For the Social Security field, it is probably better to have a macro run on
exit from the formfield that uses the .Result property of the formfield to
insert the dashes at the appropriate places.

See "Please Fill Out This Form"

Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

Sarcasm won't get you anywhere around here

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
 
M

Mark Tangard

This is, after all, a free forum; nobody who answers questions gets paid
for it; and your initial post was fell into the sadly growing category
of people who simply post their raw wishlist ('what I'd like is...'),
with no code or anything else to evidence that they've done any real
work themselves.

That said, IF you're still reading, and if this is a protected form
document, you can get what you want by placing a macro like this:

MsgBox "Don't forget the area code."

in the On Entry box of the field, in the Field Options dialog.
 
M

Method

Ok, thanks for the help!

However, if this were a form accessed by other users, they would likely
not be able to execute the msb command because that runs as a macro and
security settings default to not use macros, is this correct?

The only way for them to run this would be to set their security
settings lower, or for me to get my go digitally signed with a
certificate. Is this right?
 
J

Jonathan West

Method said:
Ok, thanks for the help!

However, if this were a form accessed by other users, they would likely
not be able to execute the msb command because that runs as a macro and
security settings default to not use macros, is this correct?

The only way for them to run this would be to set their security
settings lower, or for me to get my go digitally signed with a
certificate. Is this right?

That is right.
 

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