Edit listbox selected items and save to workbook???

**madforit** · 04-20-2012, 03:59 PM

Hi guys i was wondering if it's possible to edit the values of selected items in a listbox and save them to the workbook and update de listbox???

thank you for your precious help :-)

**davesexcel** · 04-20-2012, 08:27 PM

Hello,
You have not mentioned what type of listbox this is, I will assume it is from the controls tool bar, as the code is compatible with a userform
You cannot edit the list box items in the list box, you can select the item and send it to a textbox, in the textbox you can edit, then send it back to your source range, then repopulate the list box.
This is the code you will find in the sheet module.

Please Login or Register  to view this content.

Click the Populate Listbox button
Select an item from listbox to send it to the textbox
Edit the Textbox item
Click the button to reset the list box.

See attached example

**madforit** · 04-22-2012, 04:35 PM

Thank you so much Dave for your help but can i edit the value in a especific column of a listbox? In my attached file i would lite to edit the Quantity column of a selected line with a button calling a msg box to input the new data...

i´ve translated the userform i want to change to english (RED Userform) the rest of it is in Portuguese...

Stock form.xls

I would love any help i can get... Thank You ;-)