Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Validation - Time Format
Wondering if there is a simple solution to this one (I really hope so!). I
am using a serious of userforms to collect data and write it into the spreadsheet, some of the data to be collected is in Time or Date format. I have found a way to check the users entries as far as dates go, so they are forced to enter hh/mm/yy, is there something similar does anybody know that I can use to check the format of the time entries, ie hh:mm. I'm really struggling with this one! I know there are calendar and date pickers but with the number of fields involved I just wanted to keep it simple - famous last words I know! Thanks in advance to someone much more clever than I! -- Zani (if I have posted here, I really am stuck!) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format textbox to time | Excel Discussion (Misc queries) | |||
Format a Userform textbox to Military time | Excel Programming | |||
Format As TIME In A TextBox | Excel Programming | |||
TextBox in UserForm with 24h time format | Excel Programming | |||
textbox validation | Excel Programming |