Thread: ending vba
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default ending vba

You could use

End

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arnold Klapheck" wrote in
message ...
I am sure this is super simple but cannot find it anywhere.

I am running subs that call on a list of other subs, I want to test
something and stop vba from running. So far it just exits the sub I am in

and
continues to run the next sub. How do I shut down VBA completly and take

user
back to the Excel Spreadsheet?

If PName = "" Then
x = MsgBox("You must enter a Participant Name", vbCritical, "Error")
Application.Goto Sheets("Program

Controls").Range("ParticipantName"),
True
'Here I want to stop running ALL VBA code not just this subroutine
End If