On Error command

[Sade]

I am using an On Error command to ensure the user inputs a properly formatted date in the userform. It prompts the user that the entry is improper, then loops back to the top of the macro and asks for input again.

The first time through, it works fine. However, after being sent back to the top of the macro, the On Error command doesn't work. It reaches the same test spot, and if it is still an invalid entry, the macro fails with a "Type Mismatch" error, instead of going to the designated On Error portion again.

I hope this makes sense, and thanx for any insight you can give on this issue.

Travis

 

[Zack Barresse]

There are usually better ways than using an On Error type command for ensuring a correct date is entered in a userform. Might I suggest three seperate fields? One for the month, day and year; each using a combobox (drop down) where YOU can control what they choose. Then you can construct a date from the entries and you know exactly what they are entering and it IS a good date.

And btw, it's probably failing in lieu of your variable declaration.

 

[Sade]

Hmm, good point. I'll try breaking up the date. It will probably be cleaner and safer that way.

thanx.