Select listbox items and edit in VBA

I have a problem with my listbox edit sub. Userform contains 3 textboxes to add/update/delete items (3 columns) to a list box. The items in the list are stored in a sheet. I want the user to select any item from the list and update the items from the textboxes. The textboxes populate the listbox selection. The code works to populate except that 1.) when an item is selected, the actual update is applied to the last item in the row and not the user selected item from the listbox.

Please Login or Register  to view this content.

Best regards.

Can you provide the workbook? With userforms especially, it is very hard for us to re-create the environment to see what is going on...
Clean out any sensitive data, we just need a few rows of random data, and the userform in question.

You need to set miRowNo_Current to the row the data has come from and you can probably do that by using the ListIndex property of the listbox.

Please Login or Register  to view this content.