VBA Function: IsMissing

The VBA IsMissing function returns False if the optional argument has been provided or True if it has not.



Example of Usage

Using the IsMissing function to check if the optional argument lastName has been provided (and avoid displaying the name in the dialog box if it has not been provided):

Sub displayInfo(firstName, Optional lastName)
    If IsMissing(lastName) Then
        MsgBox "My name is " & firstName
        MsgBox "My name is " & firstName & " " & lastName
    End If
End Sub

Sub example()
    'Returns: My name is John
    displayInfo "John"
    'Returns: My name is John Smith
    displayInfo "John", "Smith"

End Sub