View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default If a called sub exit, how to the caller exit right away?

On way is to put the error handler in Sub1 and not in sub2.


--
Regards,
Tom Ogilvy

"luvgreen" wrote in message
...
Good morning! I have a question to ask experts. The main sub will a sub2,

if
there is error in sub2, sub2 will pop a message and exit. How can I make

the
main sub exit right away without running other code behind calling sub2?
thanks.