I am working with 27 ComboBoxes on a UserForm that all work to form a model code. I have two questions...

First Question:
How do I make a private sub that is a change event if ANY of the combo boxes change?

Instead of:
Private Sub ComboBox1_Change()
Private Sub ComboBox2_Change()
Private Sub ComboBox3_Change()
...
...
...
Private Sub ComboBox27_Change()

Use This:
Private Sub Any ComboBox_Change() - how do I do this?

Second question:
How do I refer to a variable combo box?

If n = 5, then refer to ComboBox5

Thanks for any help you can offer...

Rookie