I have a listbox containing 20 rows. Some of them have the same values.


The form containing the listbox also contains a textbox where the user
is able to change a value in the listbox. I want to change this
functionality so that all rows with the same values are updated instead
of a single one.

This is the current code:

Dim lngRowNumber As Long
lngRowNumber = lstObj.ListIndex

'Add 14 to the row number as we start at row 14
Range("B" & (lngRowNumber + 14)).Value = txtChange.Text

Can someone please help me?

Regards,

S