Error handler resume
Arne,
Surely you don't the If as you have the select case
Handler:
Select Case Err.Number
Case 600
'do something......
Case 666
Msgbox "666 error"
Resume Next
Case Else
msgbox "Give Up"
End select
NickHK
"Arne Hegefors" ...
I have a sub in which I call an error handler if certain requirements are
met. I call the error handler and give a message to the user but I want to
continue where the error was. Now it contnues in the main sub for some
reason.
Code for error handler:
Handler:
Select Case Err.Number
Case 600
.......
If Err.Number = 666 Then
Resume Next
End If
end select
and in the sub I call the error handler for that particukar error using:
Err.Raise 666
Please help me out here! Many thanks in advance!
|