|
-
Aug 16th, 2005, 12:25 PM
#1
Thread Starter
New Member
[RESOLVED] Multiple ComboBoxes Change Event? And ComboBox(variable)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|