Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validate date entry in a text box.
Hello:
I’m using Excel 2003, and I have a UserForm with a text box that requires a date input, but I’m having difficulty with users making invalid entries. I’ve posted this question in a different forum and the answer was, “Why not use a calendar control in your UserForm instead”. This is an excellent idea and I plan on doing this but until I’m able to write such a procedure, is there a way to write code that will: 1. Validate the entry is a date. 2. Validate the entry is not greater then today’s date. Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validate duplicate entry in a column | Excel Discussion (Misc queries) | |||
Validate Email address entry | Excel Discussion (Misc queries) | |||
Validate in WS to prevent dual data entry | Excel Worksheet Functions | |||
Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
Convert Text Entry to Date Format | Excel Discussion (Misc queries) |