Testing Listbox.Value = Null 1

[f64]

On a multipage userform, I would like to verify that a selection has been made in a listbox when the form is advanced to the next page.

If ListBox.Value = Null Then
Statement1
End If

When reaching this statement during debugging, ListBox.Value is shown = Null, but the statement isn't evaluated as true, and Statement1 is not executed. Is Null not a valid condition to test against in an If statement?

 

[PHV]

Replace this:
If ListBox.Value = Null Then
By this:
If IsNull(ListBox.Value) Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[easynoweasy]

Thanks I was stuck on this too. See, a search is often better than asking the same question twice.