vba test optional argument code example

Example: vba test optional argument

Sub MySub(Optional pParam As Variant)
   If IsMissing(pParam) Then
      msgbox "Missing"
   End If
End Sub