The ListIndex property of the list box will be -1 if no selection
has been made.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"tjh" wrote in message
...
Hello,
How can you describe a blank value in a listbox. Such as if the
user did not
choose a value.
I started the following code and the value is not working
correctly.
Thank You
If listbox.Value Is Null Then
MsgBox ("Please make a selection")
Else
End If