VBA skips on a check if Listbox.Value is Null ? 1

[VBAguy22]

Hi,
I am trying to build an If statement to catch the case where user forgets to select a listbox value. For some reason VBA skips it, keeps on going and crashes when the value is to be used. What am I doing wrong?


If (Sheets("Menu").ListBox1.Value Is Null) Then
MsgBox ("Please make a valid selection")
End

 

[PHV]

Perhaps something like this (typed, untested) ?
If Trim(ActiveWorkbook.Sheets("Menu").ListBox1.Value & "") = "" Then

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

 

[VBAguy22]

Super!
Thanks