Edit listbox value and worksheet value

[MAPeX]

Hi

I currently have a userform (SPPR) with a listbox (ListBox1) which contains the data from a worksheet called "Log Sheet". The data is pulled in by VBA code as below

Please Login or Register  to view this content.

What I have tried to do is have it so that you can edit column 9 ( ListBox1.Column(8, ListBox1.ListIndex) ) of what you have double clicked on.

What I have so far is

This is the code for the double click on the listbox

Please Login or Register  to view this content.

This is the code that once the Userform1 opens theres a drop down box that uses a vlookup to enter a value into a caption box. I have a command button to confirm edit

Please Login or Register  to view this content.

This changes the value in the visible ListBox, but doesn't change the value in the worksheet "Log Sheet".

Im stuck as to how to do this. Anyone got any ideas.

Thanks in advance

Mike

[rcm]

explicitly populate the cell in the log sheet

[Norie]

Mike

Write the contents of the listbox back to the worksheet.

Please Login or Register  to view this content.

[MAPeX]

Mike

Write the contents of the listbox back to the worksheet.

Please Login or Register  to view this content.

Norie

Thanks for that, works great. CHeers