PDA

View Full Version : userform date validation



elsteshepard
11-12-2008, 07:47 AM
Thanks for all the input on my previous question. Now i've got the template to complete, i thought i'd make the userform a little but more interesting.

In the userform I have a start date, and an end date

I want both to be displayed in the textbox as "01/01/08" (for example)

and i'd like some kind of validation - so that the end date can't be before the start date.

Also, where would I put this code? i.e. which 'private sub'

fumei
11-12-2008, 11:31 AM
"where would I put this code?"

If the controls are on the userform, then the code for it has to be in the userform module.

I suggest you look up, and try to understand, Scope. It is a crucial concept.