Hi all
I don't understand the problem with this:
If I input a number it works fine, but if I input a letter (or press cancel) it gives me an error. I thought the IfNumeric should have taken care of that, no?
Please Login or Register to view this content.
Last edited by VanniFucci; 04-01-2013 at 06:17 AM. Reason: Use code tags in future.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
All done, apologies I'm new here
Last edited by VanniFucci; 04-01-2013 at 05:49 AM.
ChangetoPlease Login or Register to view this content.Please Login or Register to view this content.
Thank you now it works. Could you explain the reasons behind it? I thought to declare the variable as a number (as opposed to text) was the way to go...
You had already put a check in place to ensure that if its not a number, the code should exit sub. So the variable had to be declared in such a way that it allows all types of entry.
Understood thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks