Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Error handler that does not end macro
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Arne Hegefors, post: 6164811"] I have an error handler that I use extensively. However most of the times I just want to be able to inform the user of the error and then move on. Sometime I save info on errors too. However they way that my error handler works now is that it terminates the program when an error is being detected. Please help me modify it so that it “tolerates†mistakes and just warns the user of the error. My code is: Public Sub mainProgram() ….. On Error GoTo Handler Exit Sub Handler: Select Case Err.Number Case 600 Msgbox(“Error type 102â€) Case 601 Msgbox(“fatal error!) ……… Case Else End Select End Sub And in a sub somewhere in the code e.g. : If x > 10 then Msgbox(“Wrong!â€) Err.raise 601 End if As you can see if error occurs the error handler is called and when the code for current error is finished the macro ends. Instead I want to call the handler, do whatever it is I want to do for a certain error but then continue in the sub where I left with the error. Please help me out! Thank you very much in advance! [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Error handler that does not end macro
Top