VBA provides the
Exit Sub and
Exit Function statements, should you want to exit from a procedure before the procedure would terminate naturally. For instance, if the value of a parameter is not suitable, you might want to issue a warning to the user and exit, as Example 6-6 shows.
Example 6-6. Using the Exit Sub Statement
Sub DisplayName(sName As String) If sName = "" then Msgbox "Please enter a name." Exit Sub End If MsgBox "Name entered is " & sName End Sub