For Loop Combo Boxes with If Statement

You replace the value in the listbox, with the correct value.

This line changes the value in column 2 of the seleced row to "Changed Value"
Listindex returns the row selected in the listbox (zero based).

ListBox1.List(ListBox1.ListIndex, 1) = "Changed Value"

Whichever way works best for you I'd guess.. a couple input box dialogs perhaps?