IsMissing Function

Syntax

IsMissing(variantvar)

Group

Variable Info

Description

Return the True if Optional parameter variantvar does not have a default value and it did not get a value. An Optional parameter may be omitted in the Sub, Function or Property call.

Parameter	Description
variantvar	Return True if this variant parameter's argument expression was not specified in the Sub, Function or Property call.

Example

Sub Main
Opt 'IsMissing(A)=True
Opt "Hi" 'IsMissing(A)=False
Many 'No args
Many 1,"Hello" 'A(0)=1 A(1)=Hello
OptBye '"Bye"
OptBye "No" '"No"
End Sub

Sub Opt(Optional A)
Debug.Print "IsMissing(A)=";IsMissing(A)
End Sub

Sub Many(ParamArray A())
If LBound(A) > UBound(A) Then
Debug.Print "No args"
Else
For I = LBound(A) To UBound(A)
Debug.Print "A(" & I & ")=" & A(I) & " ";
Next I
Debug.Print
End If
End Sub

Sub OptBye(Optional A As String = "Bye")
Debug.Print A
End Sub