Catch Changes in Multiple ComboBoxes

[NMeeker]

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 ...

For x = 1 to 60
   UserForm1.Controls("ComboBox" & x).Value = "your value"
next x

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?

 

[Jaafar Tribak]

Try doing a search on the board for generic events via Class modules . This has been addressed many times before.

Post back if any probs.

Regards.