VBA Userform - Multiple Comboboxes - Same Data

Good Morning!

I have 20 comboxes that will need to have the exact same info in them... is there a way to make it so that Code is written one time for all of them?

Or do i have to repeat over and over and over?

Please Login or Register  to view this content.

Hi Jeff!

Thank you for your response. When you say Event Handlers do you mean like based on the response in the combo box something else happens? If so, then no.

If not, then I am afraid that I am not following... can you explain?

I have uploaded a sample of what I am working on here... the fields on the "Adult" and "Children" tabs are not yet programmed to put the info onto the main sheet yet.

Ideally, I would like to make it so that instead of all of the Adults and Children options being there, that the people are asked to enter the number of adults and number of children, and they are just given input for each of those numbers.

But I do not know if that is possible????

When I added the above code to the file, I get a "Complie error: Next without For"

Originally Posted by snuffnchess

When you say Event Handlers do you mean like based on the response in the combo box something else happens?

I mean Subs that handle events like Click or Change. You do not use these for your comboboxes.

Thanks to humdingaling, sorry I missed that End If. I put that code in and it seems to work, although the combo boxes also have a lot of blank rows at the end. You should redefine the name relationship to be

=relat!$A$2:$A$25

Thank you! This works perfectly!!!

You're welcome and thanks for the rep!