End Sub, End complete procedure

[Guest]

Have stumbled on the fact that I can use "end sub" (with message box) if that
process is not to continue.
I have other message boxes that are to exit the complete procedure, which
consists of 12+ "call" routines.
How do I "cancel" the balance of the routine OR jump to the end of the
routine?

 

[Guest]

Hi Beejay

Try using a public variable set at module level of type Boolean which gets
set if you should exit all routines. Be careful to set the default values
when you app opens / changes

 

[Guest]

Sorry, this is greek to me.
Are you indicating a "public" call routine which has code to exit the process?
What default values are you referring to?

 

[Ardus Petus]

You can use End instruction
(Just End; not End Sub or End Function)
That will exit all code.

HTH

 

[Chip Pearson]

The Exit Sub statement will exit the current procedure and return
to the called procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Greetings All:
"end" does the trick
"Exit Sub" - Good to know.
Thank-you