View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Listbox no selection

Hi John

If nothing is selscted then the ListIndex property is less than zero. Zero
is the first item in the list.

HTH. Best wishes Harald

"John" wrote in message
...
How do I tell when no selection has been made when a user has clicked OK
on
my UserForm that contains text and list boxes? I get the text box input
and
the listbox selections fine, but none of the following tests identify when
the user fails to select anything in the list box.
If IsEmpty(InAIOwner) Then MsgBox "..."
If Len(InAIOwner) = 0Then MsgBox "..."
If InAIOwner = "" Then MsgBox "..."
How do I test for no selection?

I appreciate your help, -John