
May 5th, 2004, 04:25 PM
|
|
Registered User
|
|
Join Date: May 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
VBA Combo Box Help Needed - Excel
I have written a program in Excel using VBA. In the program, I dynamically create combo boxes based on an external file. So, the amount of the combo boxes vary depending on the file used. For each combo box I need to have code for the Change and Dropdown Events. Right now, I am creating the code on the fly when each combo box is created.
Each Combo Box has almost the same code(it varies depending on the combo box number. ie Combo1 or Combo2 will pass a 1 or 2 respectively to another function). Is there a way that I can write one function, ActiveX Control, etc that will control the code for all of the Combo Boxes Change and Dropdown Events?
Any help would be much appreciated.
|