PDA

View Full Version : Updating Data on a Worksheet from a Userform (Excel '97)



phendrena
06-23-2009, 01:35 AM
Hello,

I am currently setting up an 'Administration' userform that will allow certain people the ability to change and modify aspects of the data on a worksheet.

The data that they update is taken from different named ranges. The data is then placed into a listbox. The user will then select an item in the listbox. The user can then modify the selection.

I can get the data into the listbox but need code to update the selected listbox item.

Would anyone be able to help?

(Example attached)

Thanks,