Trying to determine if a list box item is selected

[CWicklund]

Hi All,

I have a simple userform and am struggling to find a way to make sure something is selected in the list box before the data is transferred to a table.

Here is one of the various things I have tried. For some reason the SelectedItem method isn't found and I get "method or data member not found". I have double checked this is indeed a list box, and the name is correct.

Please Login or Register  to view this content.

I also tried the SelectedItem = -1 version of the above.

Here is another one I tried, but it doesn't allow the Exit Sub to work properly

Please Login or Register  to view this content.

Any help is greatly appreciated, Thank you.

[nigelog]

You mention "listbox" but your code addresses "Comboboxes" ??

[CWicklund]

That's referencing a combobox to determine if the rest is required. The ModelListBox selection is the second step, and what I need.

If the combobox has anything other than Loegring then a model must be selected from the list box.

[xlnitwit]

Hi,

Is it a multiselect listbox? If not, all you need to do is test if its ListIndex property is greater than -1; if it is multiselect, then you need to loop as in your example, but your Exit Sub will always run the way you had it written.