I don't think I would use a textbox to get a date from a user.

I'd have no idea what this string actually means:
01/02/03

You may want to consider using a calendar control.

Ron de Bruin has some notes:
http://www.rondebruin.nl/calendar.htm

TUNGANA KURMA RAJU wrote:

how to Validate a TextBox entry with 3 conditions in Userform?
Textbox2 entry must be a date,that date must be of current month & current
year and it should be greater than TextBox1 date.

--

Dave Peterson