very roughly:

do
x=x+1
if worksheets("sheet1").cells(x,1).value="" then exit do
if worksheets("sheet1").cells(x,1).value="Player" then _
worksheets("sheet1").cells(x,2).value=ComboBox1.Te xt :
worksheets("sheet1").cells(x,3).value=ComboBox2.Te xt
loop


should work after you will adjust for your needs

*** Sent via Developersdex http://www.developersdex.com ***