VBA IsMissing Function: The IsMissing function in VBA checks if any parameter to a procedure is missing or not. It returns a Boolean value True if the specified parameter has not been provided and returns False if the argument has been supplied.

Syntax

Parameter

ArgName (required)– This parameter represents the name of the argument that you want to check.

Return

This function returns a Boolean value True if the specified parameter has not been provided and returns False if the argument has been supplied.

Example 1

Output

The var is missing TRUE
VBA IsMissing Function

Example 2

Output

VBA IsMissing Function

Pin It on Pinterest

Share This