Select row by first cell's contents, then past in values.
 

OK, I'll try and lay it out really smooth for understanding...

What I want is to have a code that checks down the first column on a
sheet for a specific value, call it PLAYER, and then when it finds
that value, it copies the text from some TextBoxes into the cells in
that row.

I don't know the right code for it but i imagine that it goes
something like this:

Dim Player As Object

Set Player = ComboBox1.Text

Check Range(A:A) For "Player"
Then when you find "Player",
the cell in the same row, but the next column across = TextBox1.text,

the cell in the same row, but the next column across from that =
TextBox2.text,
the cell in the same row, but the next column across from that =
TextBox3.text,


any help you can offer would me massively appreciated.

Ben

Select row by first cell's contents, then past in values.
 

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 ***