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?
"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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.