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!

--
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.

--
Regards,
Tom Ogilvy


"Zani" wrote in message
...
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!

--
Zani
(if I have posted here, I really am stuck!)

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!)



"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"Zani" wrote in message
...
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!

--
Zani
(if I have posted here, I really am stuck!)