G
GoBow777
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
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