Listbox no selection

J

John

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
 
H

Harald Staff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test for no listbox selection 1
Generated text copies into another template 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Multi-select listbox - mousedown event 2
Prompt For Replace in Selection And More... 0
Link a text box based on drop down box with four options MS Word 365 0
Creating a Search using a combo box and then creating a report. 4
Menu driven PowerPoint presentations 0

Top