VBA - Userform; Check if at least one selection has been made in Listbox

Hello everyone,

Wondering if I could have some help with a small problem in my userform to add data to a sheet?

To do so, I made an userform that gives you four fields to fill/select. Text box: New restriction name, Text box: Row # to add line, Listbox: Select Board category, Listbox: Select financial manager

With the code I have now, it is successful in bringing over the data. However, when checking the userform to insert data, I noticed that if you did not select any options for the any of the listboxes than it still would enter the text box data and leave the other fields blank and not ask that no selection has been made and thus requiring to do so like if you left a text box empty.

For simplicity: The code (in insert data button in userform) for the checks work for the text boxes but not the listboxes. Thought I could find a quick solution but have not been able to, I would think this would be quite simple but need some help if anyone knows a way.

Please Login or Register  to view this content.

Thanks,
Ant

If nothing has been selected in a simple UserForm's ListBox, then that ListBox's ListIndex will be -1. For example...

Please Login or Register  to view this content.

Awesome, it works perfectly!

Here is the code that was adjusted...

Please Login or Register  to view this content.

Thanks for the help @Rick Rothstein and @nigelog

Thanks,
Ant