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 :-)
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 :-)
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.
Click the Populate Listbox buttonPrivate Sub CommandButton1_Click() ListBox1.List = Range("A1:A8").Value End Sub Private Sub CommandButton2_Click() Dim OldS As String, Vl As Range, NewS As String, c As Range OldS = ListBox1 NewS = TextBox1 Set Vl = Range("A1:A8") For Each c In Vl.Cells If c = OldS Then c = NewS Next c ListBox1.List = Range("A1:A8").Value End Sub Private Sub ListBox1_Click() TextBox1 = ListBox1 End Sub
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
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 ;-)
I've tried to change the code to use it with a list box with 6 columns but I don't know how to get it to work :-( any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks