auto filling the combo box

Hi all

i was wondering how i can incorperate this code into my workbook

Please Login or Register  to view this content.

Thanks
Keith

Thanks for your response, but i have tried that and the comboboxes do not populate

Please Help

Keith

thanks for responding

ok here it is, the original post attachment new1.xls does not populate the names when the form is activated, so i made a sample
workbook called userform.xls, and some nice person answered with the code below.

Please Login or Register  to view this content.

so i copied it into the workbook called userform.xls, and it works perfect, i can change the name to any name right before
i activate the form, and it works perfect.

So i copied and pasted it into the workbook called new1.xls and tried to change some things like the name of the comboboxes,
sheet names, the 1 to 6, to 3 to 8, and had no luck making it work, i'm just new to excel and asking for help, i'll attach both
workbooks so you can see how good the code above works in userform.xls workbook. i hope i explained myself a little bit better
this time.

Thanks
Keith

Thanks HaHoBe

but unfortunately everything I tried was unsuccessful changing combo boxes, I guess I need to start with getting the names in 1st which
was successful, then get the rest of the code to do what it already does.

Thanks
Keith

Thanks HaHoBe, I'm sorry but I'm not very good with code at all, people here are awesome at it, I keep trying to change things to get it to work, but
can't get the comboboxes to populate at all, the program works great except for that tiny piece of the puzzle.

Thanks
Keith

Thanks for responding HaHoBe

I saved the EF989590.xls to desktop, it opens on team3, used ctrl shift D, and the userform1 pops up, but nothing populates the userform
am I doing something wrong?

Thanks
Keith

I have a question about the forms, is it possible to use the userform that just picks up the names, with this code

Please Login or Register  to view this content.

and add a command button that will activate form 2 and hide form 1, but copy whats in the comboboxes to form2 and then let the
code work its magic, just s thought.

Thanks
Keith

ok earlier post has 2 excel books, the userform.xls is what I would like to happen in the new1.xls

the "new1.xls" userform1 works perfect, don't want anything to change, except to incorporate the way
"userform.xls" populates the comboboxes, is that possible?, if not, I will try to figure another way with
maybe textboxes or something, the reason for the comboboxes, is so that the players may play the same 6
players or maybe subctitute someone that week player 7 thru 17 "subs" 1 thru 6 are the main players each week.
I just can't seem to figure out how to populate the comboboxes when activated, I don't want to use the drop down
if I don't need to, 95% of the teams will play the same 6 players, so if their names are already there, I only have to
click on an option button that matches how many games they won 0,1,2, or 3 and the score is inputted.

if this isn't possible please let me know and I will attempt to figure out another way.

Thanks
Keith

thanks HaHoBe, but I must be doing something wrong, or explaining it wrong, I don't need anything done to the userfom workbook, I
just need what it does to the workbook below.

Thanks
Keith