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?
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?
"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?
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:
[VBA]On Error Resume Next
'Your Code here which errors at closing
On Error GoTo 0[/VBA]
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------