Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I convert date/time formats differently? | Excel Discussion (Misc queries) | |||
What exactly does the asterisk mean in the Date/Time formats? | Excel Discussion (Misc queries) | |||
formulas using date/time formats returning #value | Excel Discussion (Misc queries) | |||
Multiple Date/Time Formats | Excel Worksheet Functions | |||
US vs UK date and time formats | Excel Discussion (Misc queries) |