Collections of control - evaluating the name of a control that has been "pressed"
I have created a form in Excel, upon which is a multipage control, with a set of combo boxes placed on. One combobox is populated by a pre-defined list of text, which upon user selection runs a macro that defines the population of a second combo box.......like a choice - sub-choice set up.
The user is able to add and delete pages to their requirements, which also add and deletes the combo boxes on each page, however the user will always be presented with the same choices for each page but at any given time the coices on individual pages may or may not match the choices on others.....at least that's what I want.
I want a common code that operates on ALL combo boxes, however my problem is that because each combobox has a different name they would usually require a separate code behind them.....or at least a piece of code that points to a common one.
Is there a way in which I can get a piece of code to operate such that it will look for changes in ANY combobox regardless of the page it is on (possibly use a control collection?), evaluate the name of the combobox that the user has activated then pass that name onto another macro which will use it to populate the "sub-choice" combobox that is associated with it.
Thanks for any ideas or solutions!
