There will be *no* way you can tell if the date is in dd/mm/yy or mm/dd/yy
format for month and day combinations less than or equal to 12. For example,
if I entered 4/6/09 into your TextBox, how would *any* routine know whether
I meant April 6th or June 4th? Your best bet is to use a calendar control of
sort where your users can pick the date from a monthly display.

--
Rick (MVP - Excel)


"zak" wrote in message
...
Hi

I was wondering if anyone can let me know how to add validation to text
input boxes on forms?

I have several forms on a spreadsheet that I am creating and there are
quite
a few time and date input boxes, which I was hoping I could add validation
to
so that the information is entered in the correct format? i.e. date should
only be in dd/mm/yy, time should only be entered like hh:mm etc.

Can this be done?