Hello,
I am running a macro that asks a user to input a date to parse some data from a file folder. The issue I'm having is keeping an error from popping up (Run-time error '13': Type mismatch) when the user selects "Cancel" or "X"s out of the inputbox. Here is the pertinent code.
I have also tried the following codes to prevent the error.
Please Login or Register to view this content.
Please Login or Register to view this content.
Try something like this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hello Lewis,
You declared eDate as a Date Type. The Cancel button returns a Boolean type. To fix the problem, change eDate to a Variant Type.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you both for your quick responses.
I found a solution and was going to delete this thread, but since there are solutions posted, hopefully this will help another.
Here is the solution that I found so that I could ultimately check the date against another date in a different format later on in the VBA programming.
Please Login or Register to view this content.
Hello Lewis,
FYI, using a Variant instead of string, eliminates the need to convert the string to a date. The Variant type does this for you.
I would respectfully disagree. The Variant from the Input box is still a string and couldn't be compared directly to a serial date without converting it to a serial date.Originally Posted by Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks