Excel VBA

Question

When you have nested subroutines and want to exit the application is there a command that will do this. Exit Sub takes you back thru the nested hierarcy. Thanks

Bay Wolf · Answer

You can just use End Sub where you want to exit is one way.

The other is to use a GOTO statement.

Example

Sub

GOTO PROC_END

end sub

PROC_END: 'this is where the GOTO statement will take you. Note, there is a colon after the name.

end sub

Message Edited by Bay Wolf on 12-16-200611:06 PM

Bay Wolf · Answer

:smileymad: Double post.       Message Edited by Bay Wolf on 12-16-200611:04 PM

Crosbylake · Answer

Thanks, but this is not what I am looking for. I want to terminate the VBA Excel application (from within a nested subroutine) without having to trace back thru the nested subroutines (back to the origional calling sub). Crosbylake

Windows General

Excel VBA

Was this post helpful?