Good to hear that Peter, and thanks for letting us know.

Bob

"Peter" wrote in message
...
On Sat, 9 Oct 2004 11:38:02 +0100, "Bob Phillips"
wrote:

Peter,

The combobox value is obtained using

Combobox1.Value

You can use this value with a worksheet function to find the row

myRow = WorksheetFunction.Match(Combobox1.Value,
Activesheet.Range("A:A"),0)

and then directly load the cells

Activesheet.Cells(myRow,"E").Value = txtName2.Text

etc.

many thanks Bob,

It worked like a dream - exactly what I was after


--
Cheers

Peter

Remove the INVALID to reply