IsNull Function

Tests if a Variant contains the special Null value, indicating that the variable does not contain data.

Returns True when an object variable is passed that does not refer to a valid object, such as a newly created object that has not yet been assigned or an object assigned to the Nothing literal.

Syntax:

IsNull (Var)

Návratová hodnota:

Boolean

Paremetre:

Var: Premenná, ktorú chcete overiť. Ak Variant obsahuje hodnotu Null, funkcia vráti True, inak vráti False.

Null - Tato hodnota sa používa na vyjadrenie neplatnej hodnoty.

Príklad:

Sub ExampleIsNull
Dim vVar As Variant
    MsgBox IsNull(vVar)
End Sub