Hi
I have a Error Handling routine that is not working. Could someone please have a look and see where I went wrong.
Basically, when the error occurs it does what it is supposed to do which is display message box, focus and clear text box. However, when there is not an error the main code executes the way it should but still displays the error message box.
Thanks
Please Login or Register to view this content.
Are you sure it is not just that you are getting an error from one of those lines?
comment out the "on error" line, run it on some supposedly good data and tell us what like it errors on and what message.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Hi no1uno,
Is your code behind a worksheet or in a Module? If it is behind a worksheet, insert a real module and put the code in there. Try the below.
http://www.cpearson.com/excel/Scope.aspxPlease Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks