Date and Time Formats in UserForms

[Guest]

I can insert the current date and current time into textboxes on a UserForm,
what I need to do is completely set the format so that if the user tries to
enter the date or time in the wrong format the Userform wont accept it and
gives them a message saying so.

I want to use dd/mm/yy for the date and hh:mm (24 hour clock) for the time.

Any ideas - am stuck now!

 

[Tom Ogilvy]

There are no validation settings for these controls. You would have to use
the control's built in events to execute code that does the validation.

 

[Guest]

Thanks Tom. Sorry for being ignorant here, but could you show me an example
of what you mean, I'm not sure I understand - maybe my brain is just fried!
--
Zani
(if I have posted here, I really am stuck!)

There are no validation settings for these controls. You would have to use
the control's built in events to execute code that does the validation.