vba argument is set code example

Example: vba argument is set

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