Run Time use of ComboBox

[SeanVBA]

I can create a combobox at runtime, additems, etc. But I can't seem to find a way to detect when that new box has been changed. I can read it if I click on another, pre-existing control, but that's not the intent. thx

 

[Hermanito]

When you add a combobox at runtime, there is no eventhandler attached to it where you catch the change event.

There is a way to do this, but you need to work with classmodules. I don't have an example at hand, but maybe someone else can provide.

Do you really need to create them at runtime? Otherwise you could easily use the eventhandlers provided when creating them at designtime...

 

[SeanVBA]

thanks - I'll look into classmodules.

I could create at designtime but I was hoping for uncontrained inputs. Designtime is my backup plan.

 

[Norie]

What 'constrained input'?

How many comboboxes are you going to have?

 

[SeanVBA]

Unconstrained input. Could be 30 or more comboboxes. The form is to allow the use to request parts. Each part has 6 option cases. Color, size, etc. I have a command button that creates a row of comboboxes for each part. The trick is that not all sizes come in all colors. So for each part, the user selects a size, and then (here's the trick part) the color combobox updates in response to the size selected. I'm stuck because I can select a size but vba doesn't see the action. (thanks for your help~!)

 

[Norie]

Why do you need 5 comboxes for each part?

What if the user needs more than 6 parts?

Have you considered something like this?

5 comboboxes, a listbox and a command button.

The user picks the part, colour, size etc then presses the command button.

The command button has code which transfers their choices to the listbox and then resets the comboboxes ready to go again.

Once the user has entered all the parts they want they hit another button to transfer the data to a worksheet, or whatever.

Would something like that be any use?

 

[SeanVBA]

hmm. I hadn't thought of that option. That's work much better than my original plan, actually. Thanks! Still curious about talking to that combobox, but I think I'll move on.