Error Detection

[Pherion]

Ok, so I have built up quite a few macros for automating functions in some spreadsheets, and I want to start being able to detect when errors occur. Right now I just have the function or sub terminate itself if an error occurs, but that just returns control to the calling sub/function.

I need a way to detect if an error occurs, and immedatly terminate the whole process so that it does not continue and make eronious changes further down the line.

I had thought of declaring a pubic boolean variable that i could flip if an error occurs, but I am not sure how to detect this flip without programing in an if statement every time i call a function.

Question1: Is there a way to write a function/sub that will automaticly triger if a public variable becomes a certain value?

Question2: How do I unload a macro (terminate it) from a public function? I have found that for user forms, the Unload Me command does not work in a public function. I suspect this is becasue the function is not directly attached to a form.

Thanks in advance!

[shg]

A common practice is to declare procedures as Boolean functions and have them return True if successful.

[Pherion]

A common practice is to declare procedures as Boolean functions and have them return True if successful.

I had thought of doing that. But there are a number of functions I am using that return a differnt value.

For instance, one function is setup to locate an employees record in a look-up table. I want to return the location of the employee from the function. However, if the function does not find the employee, I don't want the calling function to keep processing whatever it needs to do with the record.

So unfortunatly, having the function return a Boolean wont work :-(

[shg]

A function can (and frequently does) return value(s) in its argument(s).

Please Login or Register  to view this content.

[Pherion]

Ok, I see how this can work, but it still requires me to turn each and every function call into an If statment. There has to be a cleaner way to check for errors.

How about this:

If I define an Error function in each UserForm, and have it display a message and execute Unload Me, is there then a way to call that function from a public function without knowing necesaraly who called the public function.

So... is there a way for a public function to know who (what function/sub) called it, and then execute a public function from within that calling object?

[shg]

You can have an error handler in the calling procedure:

Please Login or Register  to view this content.

[shg]

Provide more information if you like:

Please Login or Register  to view this content.

[Pherion]

Ok, so I haven't used an error handler before in VB. Does it just display the message, or will it terminate the user form and macro as well.

[shg]

Soo ... try it

[Pherion]

Unfortunatly I cant until Monday ;;; I don't have access to my work files at home.