Return TRUE if the optional variant argument has been passed to a procedure.
Syntax
IsMissing(argname)
Key
argname The name of an optional variant procedure argument.
The IsMissing() function can be used in VBA.
Examples
Function Demo1 (Optional ArgA)
If IsMissing(ArgA) Then
Msgbox "Value not supplied", vbOKCancel, "SS64 IsMissing Demo"
End If
“Sometimes only one person is missing and the whole world seems depopulated” ~ Alphonse de Lamartine
Related:
IsNull - Is expression NULL? True/False
Nz - Detect a NULL value or Zero Length string.