Edit ListBox Items

Boechat

New Member
Joined
Jul 16, 2016
Messages
44
Hello once again, everyone. Hope you get to me help out once again on this one.

I'm handling the following issue:

I have a listbox which is populated upon form activation. Besides, the form has 3 buttons:

-An ADD button: which pops up a form to register a new entry to the listbox and the excel sheet;
-A DELETE button: which deletes the selected list item and;
-An EDIT button: to edit the entries which have already been done.

What I want to do is: for the edit button to open the "new entry form" with all textboxes filled out with the values found in the sheets. As if I had opened the form right after making the entry and not unloading it. After that, the new determined values are not to generate a new entry, but substitute the old version.

Any ideas?
Thank you all in advance!

Cheers
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top