User form combobox to fill another combobox

Hi all

i'm attaching a workbook with a userform that I could use a lot of help with, I want to run a pool league, and I made up a userform, I added the team names to the combobox, and I would like to populate the 4 comboboxes
on each side with the names that go with the team, there are 4 comboboxes underneath because there will be 4 players against 4 players and each player will have their own statistics, and they will be playing
4 games each, a total of 16 games that night. I will be asking you guys to help me with the whole userform, but would like to do it piece by piece so I can understand and learn as we go. so any help would be
appreciated.

Thanks
Keith

This will allow you to select the player names, from the relevant combos.
To simplify things I have renamed some of the Combos

is there a way to populate the 4 combo boxes with the names as soon as I pick a team, I put some names instead of player1,2,3 and 4 on team 1 and 2, so when I pick team one from the 1st dropdown, that the names automatically appear
in the boxes without picking them?, I still may need to use the drop down to pick a sub that they may have played.

but thank you so far, that will work , now i'm going to look at the code and try and learn what you did.

and by the way, that was a super fast response .


Thanks
Keith

How about

Please Login or Register  to view this content.

yes that is perfect tyvm

I added that to the form and it works perfectly, I added rep because that is exactly what I needed. but I have along way to go to finish the form, i'll attach the workbook with those changes.
and the next thing that would be cool is that when I pick from the drop down box on the side of their name that has numbers 0-27 that what ever number I pick it goes to the sheet under week1 then week2 and so on.
that is how many points the won that night.

Thanks
Keith

Thanks for the Rep.
I've made a few changes.
You'll need to rename the combos for the team2 points as cbbxT2Points1, cbbxT2Points2 etc

Yep that worked out great , but I was an idiot and kept changing the name of the wrong combo boxes DOH!. kept getting an error, so I cleared the form out and saved it again to scoresheet3, and if you can keep helping me,
the little circles in the box with 0 1 2 3 4 under wins, they play 4 games and if they won 3 games, when I click on the circle under the 3, it would put 3 wins in the win column by their name on the TEAMS sheet, is there a way to
make it keep adding up every week?, I total up the wins for the 4 players in D8 for team1 and D16 for week2 and so on, and link it back to the STANDINGS sheet. I understand some of the code now, but will be awhile before I can actually
do this stuff on my own.

Thanks
Keith

Try

Please Login or Register  to view this content.

You'll need to rename the frames Frame1, Frame2 etc for Team1 & Frame11, Frame12 etc for team 2

Give this a try

Holy Smokes you fixed all the extras, , you are a genius, it works so smooth it will save me hours a week of putting the info in by hand, tyvm .

so I figured I would tackle putting the losses in myself, figured how hard could that be, after all you would think its as easy as duplicating the code for the wins and move it over 1 stupid cell, well
everything I tried didn't work, error after error, that's the last thing it needs. can you do me one last favor?, when I click on the option button under 2, that gives him 2 wins and if I could have figured it out, he would have 2 losses in the loss column,and the option button under 3 gives him 3 wins and 1 loss, he plays a total of 4 games, so depending on his wins will determine the number he gets in the loss column. I don't have to upload any workbook, because that last one
I downloaded works great. not gonna mess with a good thing .

Thanks
Keith

Simply put this formula in E2 & copy down

Formula:

Please Login or Register  to view this content.

I tried to reply a couple of time to Thank You for all your help and I was getting blocked because of IP for some reason, well when you get this thanks Again

Thanks

Keith

Glad to help & thanks for the feedback

OMG so I showed this to some people that are getting into the league, they thought it was awesome, I'll be the one to keep track of the league, but my boss was playing with it and he was wanting to know if I could make a couple
of small changes to the form, I said I'll ask, on the bottom of the form I added 4 text boxes, not sure if that's the right thing to use or not, but all the drop downs for points, he would like to see those points in the text box added up
together so he doesn't have to close the form to see if he put the right amount in, and under the option buttons to see if he did that right also, he likes the message that comes up if you don't pick the right week, and could we do
that for the money option buttons?.

Thanks

Keith

This will do the points for team 1

Please Login or Register  to view this content.

for team 2 do the same, but with the team 2 controls.
This will warn if the fee is not selected

Please Login or Register  to view this content.

The wins is a bit more involved & I'll have a look at that when I get time

Thank you that works great

Instead of using the frame and option buttons, would it be easier with a drop down 0,1,2,3,4 ?

Thanks
Keith

Apologies, I had forgotten about this.
The simplest way is probably to add another button (I've called it "Check") & run this

Please Login or Register  to view this content.

Whilst it's not automatic, It's probably simpler than rewriting the existing code.

Thanks Again that worked , YOU DA MAN , just curious, is there a way that if Textbox 2 and Textbox 4, doesn't add up to 16, because 16 is the amount of games played, that a message box pops up and says "Does Not Add Up To 16" ?

But no matter what, you have helped me Big Time and I thank you for that.

Thanks Again
Keith

Simply add this line to the bottom of the code

Please Login or Register  to view this content.

Man o Man you are fast, and good

Thank you again for all your help, the finished product is awesome

Thanks
Keith

Glad to help & thanks for the feedback