Using Userform Listbox for data management/editing

Hi All,
I'm looking for some help/guidance.
I've attached a sample workbook, whereby I want to be able to edit worksheet data from a userform. I've managed to pull and populate the listbox correctly, but I am now getting stuck trying to not only select the data in the listbox but also to change it. I was working on it late last night, thinking it would be fairly easy, but I soon noticed it wasn't, and I had a bit of a problem searching for help as I don't know all of the correct excel terminology. At some stage, I will have a read up on the terminology so that I know EXACTLY what an ARRAY is and what it's used for.

In the meantime, if anyone could have a look and give me some pointers in the right direction, that would be great.

Thanks all

Absolute simplest way to 'link' a listitem to the worksheet is to include another column (can be hidden) in the listbox that holds the row number for that item. You can then refer to the row if you want to edit the data - add another userform laid out for data entry, use the row number to populate the controls and update the sheet afterwards.

Ok, I can see the logic in that and will give it a try later. How would I go about make a hidden column?

Obviously increase the column count... then use sometihng like

Please Login or Register  to view this content.

in the debug window to get the existing widths - it'll return the current widths like "30 pt;170 pt;60 pt;40 pt". Use that as a 'template' (you don't need to add 'pt')

Please Login or Register  to view this content.

Ah I see, quite cunning, I like that

I've had a go, and I seem to be getting VERY close. However, I can't get the data to pass across.

I've attached the latest version, is there an obvious mistake?

Does anyone have any idea what I'm missing?