Thank you so much for you reply, I will try it right away :)


Regards
NorTor



On Thu, 1 Jul 2004 12:26:44 -0500, kkknie
wrote:

Try something like this:

Code:
--------------------
Sub CommandButton_Click()

dim r as Range

For Each r in Range("A1:A" & Range("A65536").End(xlUp).Row
If r.Value = Combo1.Text Then
Range("B" & r.Row).Value = Text1.Text
Range("C" & r.Row).Value = Text2.Text
Exit For
End If

Next

End Sub
--------------------

It basically searches the A column until it finds the same thing
selected in the combobox, then puts the text box values into columns B
and C of the same row.

K


---
Message posted from http://www.ExcelForum.com/