Hi all,

I have a text box in a userform (eg. txtmydate) that I wish to accept
valid date entries only such as: dd/mmm/yyyy.

When the userform is initialised, is there a way to have the text box
display two spaces followed by a '/' and accept only 2 numeric
characters there for the day (eg. 15), and display three spaces
followed by a '/' and accept only 3 text characters there for the
month (eg. Feb), and then accept only 4 numeric characters for the
year (eg. 2004).

So the text box would initial look something like: ' / / '

and a valid entry would be something like 15/Feb/2004.


Thanks again group for your help.

Jen