IsMissing Function

Syntax:

IsMissing(expr)

Group:

Variable Info

Description:

Return the True if Optional parameter expr  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.

 

Parameter

Description

expr

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