PDA

View Full Version : cdate type mismatch



av8tordude
09-22-2011, 09:30 PM
I'm getting a type mismatch on CDate(.Date1). When I hover my cursor over the error, it displays "", meaning nothing to evaluate. I get this error whenever I close my userform. Is there an alternative or may a way for it not to ignore it?

GTO
09-22-2011, 10:44 PM
"Is there an alternative or may a way for it not to ignore it?"

Hi Aviator,

The error is obviously not being ignored, what do you mean?

shrivallabha
09-24-2011, 07:46 AM
If the above statement works fine otherwise (i.e. except at the closing userform) then you can force VBA to ignore the error for this statement by something like:
On Error Resume Next
'Your Code here which errors at closing
On Error GoTo 0