Trying to determine if a list box item is selected

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.

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

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.