I have procedure that prompts the user to input a date into an input box. The issue is if the user clicks 'OK' without entering any data into the input box, the user receives popup message of "Formula you typed contains an error." Is there a line of code I could use so this error does not popup? Instead, I would like the message to say something like "date invalid, would you like to try again". thanks
Please Login or Register to view this content.
Hello maacmaac,
I assume by the name that sDate is a string variable. Declare it as a Date and the code will work.
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!)
I did declare as date but still getting same message if user leaves the field blank. Full code below. Thanks for comments.Please Login or Register to view this content.
Hello maacmaac,
When I run the code, I don't receive any error messages for leaving either the start or end date blank. I am running Office 2010 on Windows 7.
Not sure what I am doing wrong. I attached a copy of screenshots I am getting if that helps. I'm also using 2010 and Windows 7.
Thanks.
Hello maacmaac,
Using the code you posted, I have been unable to duplicate the error. If you post your workbook then I can see if the error occurs on my system.
Per your request, sample attached. Thanks.
Hello maacmaac,
Good news! It fails for me just like it does for you! Now, to find out why.
Hello maacmaac,
Okay, not sure why my system didn't error when I copied the code and ran it but doesn't matter. In your code I changed sDate and eDate to Variant types and the InputBox to Type 2 (String) instead of Type 1 (Number). The code now checks for an empty string instead of zero. The attached workbook runs on my system and should run on yours as well.
This is perfect. Thank you.
Hello maacmaac,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks