Updating from ListBox

[Nomis_Eswod]

Hi,

I have a form with a ListBox on it that is populated from an Excel worksheet range. When a row is clicked on TextBox1 - TextBox13 displays shows the data for that row from the corresponding column on the listbox.

I have an 'Add' button so that if I enter new customer details, I can click this button and it posts the data to the next blank row on the Excel table.

I want to an add an 'Update' button so that if I click on an existing row, change the data in one of the textboxes I can click 'Update' and it updates the data in the Excel table, but I can't work out how to do it.

Any ideas anyone??

 

[Andrew Poulsom]

This:

ListBox1.ListIndex + 1

will give you the relevant row in RowSource.