I have a Form with over 60 ComboBoxes with the same information in each list. I would prevent the same item being selected in different comboboxes. (In other words, i have 60 of the same comboboxs and i need different selections in each combobox.)
Is there a way to program this without using 60 different subs, one for each combobox Change method?
Private Sub ComboBox88_Change()
End Sub
I know using something like ...
Will allow me to reference 60 different comboboxs, But is there a way to do something similar to catch if ANY of the 60 comboboxs are changed?
Is there a way to program this without using 60 different subs, one for each combobox Change method?
Private Sub ComboBox88_Change()
End Sub
I know using something like ...
Code:
For x = 1 to 60
UserForm1.Controls("ComboBox" & x).Value = "your value"
next x