On Error GOTO Quit

Guzzlr

Well-known Member
Joined
Apr 20, 2009
Messages
742
Code:
On Error GoTo Quit:
Code:
Quit:
MsgBox ("Please Add Data to Template Sheet" _
& vbNewLine & "Then Run Program")

Hello All,
I have the above code. The On Error GoTo Quit is at the top of the code, with the Quit: at the bottom. The problem is my message box keeps popping up, even when no errors are happening?
What am I doing wrong?
Thanks
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,666
Office Version
2010
Platform
Windows
Code:
On Error GoTo Quit:
Code:
Quit:
MsgBox ("Please Add Data to Template Sheet" _
& vbNewLine & "Then Run Program")

Hello All,
I have the above code. The On Error GoTo Quit is at the top of the code, with the Quit: at the bottom. The problem is my message box keeps popping up, even when no errors are happening?
What am I doing wrong?
Thanks
You have to put End Sub or End Function (depending on what type of code procedure you have) immediately before the Quit: label to stop your code from falling through.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,271
Office Version
2007
Platform
Windows
It is likely that some other error is happening and you are not viewing it.


It is not recommended to use: On Error GoTo


It is advisable to try to control each of the errors.


If you like, put all your code here to review it and adjust the code to control errors.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,141
Office Version
365
Platform
Windows
You need to exit the sub, before the Quit, like
Code:
Exit Sub
Quit:
MsgBox ("Please Add Data to Template Sheet" _
& vbNewLine & "Then Run Program")
I would also advise against using VBA keywords (like Quit) for variables, GoTos etc.
 

Guzzlr

Well-known Member
Joined
Apr 20, 2009
Messages
742
thank you all...it's working now. I got rid of the word "Quit" and used ErrHandler instead
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
36,141
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,090,452
Messages
5,414,611
Members
403,536
Latest member
JEduardo

This Week's Hot Topics

Top