Marianne,

Date input masks are tricky.

I really had this correspondence with another poster that may help you

http://www.vbaexpress.com/forum/show...light=keypress

and also this one

http://tinyurl.com/9f9dg

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MarianneR" wrote in
message ...

Hi!

I've created a User Form for people who are not experienced with Excel.
The form includes text boxes as well as pull-downs (combo boxes). I
was wondering if there was a way to use input masks (like in Access) to
prevent uses from entering inappropriate data.

For example, I have several date fields. Is it possible to have my
user form already have a mm/dd/yyyy format for them? Or, if that's not
possible, is there some way to make the User Form beep at them? I have
prompts in the labels next to the boxes, but I'm afraid it won't be
enough.

The people on this forum have been so helpful. Thank you very much.

Sincerely,
Marianne :)


--
MarianneR
------------------------------------------------------------------------
MarianneR's Profile:
http://www.excelforum.com/member.php...fo&userid=6253
View this thread: http://www.excelforum.com/showthread...hreadid=475954