vba 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
Sub MySub(Optional pParam As Variant)
If IsMissing(pParam) Then
msgbox "Missing"
End If
End Sub