Entry

How do you know if a variable is null?

Jun 10th, 2000 20:49
Jerry Yoakum,

Use the IsNull function.
A value of True will be returned if the variable's value is Null.
ex.
  Sub main()
    Dim x As Variant
    x = Null
    If IsNull(x) Then
        MsgBox "null"
    End If
  End Sub