hi all and thanks for taking the time to read my post

attached is the worksheet with the form

if you click on the combobox Team Name text boxes fillup with names, and there is 3 option buttons infront of their names
on sheet1 TEAM, there is a list of names in alphabetical order with extra colums on the right WIN,LOSS,TR,8-BALL,
Heres the hard part, or atleast it is for beginners like me, the name in the form that fills when you use the Team Name Combobox
has to match the name on sheet1 TEAM and if you click the optionbox under the 1 it fills to the right of his name with a 1 in the
WINS colum and 2 Losses in the LOSS colum, the real catch is gonna be how to keep that number there and the following week
when i call up that team again and that name appears again and i click optionbox 2 and have to keep a running total, because say for example
he wins 2 games next week and that would give him a total of 3 wins and 3 losses, and every week i have to update how many wins and losses everybody has, i have along way togo to try and make this as easy as possible using excel, and as you can see from the attachment how far i have comenew.xlsm with your guys input and time, you guys are great , i know we can get this done, just a matter of time and your guys input..

Thankyou very much
Keith