Sub SimpleErrorHandler() On Error GoTo SimpleErrorHandler_Err Dim sngResult As Single sngResult = 1 / 0 Exit SubSimpleErrorHandler_Err: msgBox "Oops!" Exit SubEnd Sub