Syntax
| IsMissing(variantvar)
| ||||
|---|---|---|---|---|---|
Description
| Return the True if Optional parameter variantvar does not have a defaultvalue and it did not get a value. An Optional parameter may be omitted in the Sub, Function or Property call.
| ||||
See Also
| |||||
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
|