Bob,

the only reference i have to these records is there unique
ID number in column A, i have searched through my records
to find these people, how do i reference to these rows?

thank you,

Robert Couchman

-----Original Message-----
Robert,

Must admit I wondered where the row was coming from<vbg.

It is not automatically stored, a coillection consists of
an index and a
value, you would know what your code stores. You can
store the row number as
the collection index, and retrieve this with

collIndex = myColl(Combobox1.Value)

or fully as

Private Sub ComboBox1_Change()
If ComboBox1.Value = "" Then
Range("AX" & mycoll(ComboBox1.Value)).Value = ""
Range("AY" & mycoll(ComboBox1.Value)).Value = ""
mycoll.Add ComboBox1.List(prevIndex),
ComboBox1.List(prevIndex)
Else
Range("AX" & prevIndex).Value = ComboBox1.Value
Range("AY1" & prevIndex).Value = TextBox1.Value
mycoll.Remove ComboBox1.List(prevIndex)
prevIndex = ComboBox1.ListIndex
End If

End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)