Hey guys!
I need your support again.
It's about Userforms / ComboBox / Check Box.
I have a table with 10 columns.
Each column is a combobox
These are uploaded / initialized like this:
Dim sheetOne As Worksheet Set sheetOne = Sheets("SheetOne") Row = 2 While (sheetOne.Cells(Row, 2) <> "") ComboBox_AA.AddItem (sheetOne.Cells(Row, 2)) Row = Row + 1 Wend
So I have 10 combo boxes where the user can select an entry.
Now I have a checkbox. However, this should not appear or be editable until one of 10 specific selections has been made.
For this I like to make a last column, which lists the entries.
Now I just do not know how I implement a suitable loop, which checks whether one of the entries was selected, etc.
Does anyone have an idea or even an approach?
Google could not help me yet.
I hope my words are enough.
Best regards