Exiting called macro on error, then ending macro caller.

Hi all,

I have a userform that when the ADD button is pressed, it calls 4 macros in succession.

If any of these macros encounter an error, I have each of them set up to display a message that an error has occurred, and then exit the sub.

The problem is, when an error occurs in the first called macro and it exits, the original macro still calls and executes the next 3 macros.

What I want to happen is when an error occurs in the first called macro and it exits, to then end the ADD button macro and not call the other 3.

Hope this makes sense and someone can help.

Thanks,

Yappa

Thanks roy, simple yet effective.

Yappa