Edit Worksheet Data From Textboxes in a Userform

[RoroBear]

Greetings All,

I'm in the process of building a budget. In a nutshell, I have a worksheet that populates a listbox, which is launched from a cmd button. There are 8 columns of information. The 6th column is blank. There 8 corresponding textboxes below that are populated when I double click a row in the listbox. I want to be able to edit/delete the worksheet data from the textboxes in the userform. The code below is all I have so, anyone can help get me on the right path i'd really appreciate it.
v/
rorobear

Please Login or Register  to view this content.

[SjonR]

we have no idea what your userform (and sheets) looks like. Upload an example-file is my advice.

[BadlySpelledBuoy]

Any chance you could attach the file (desensitize the data if appropriate).
It's far easier to help when we can see it in context.

BSB

[RoroBear]

All,

As requested, i'm including the file for better understanding. Thank you everyone for the speedy reply!!!

v/
rorobear

[BadlySpelledBuoy]

One easy to understand way would be this:

Please Login or Register  to view this content.

Note you need to move your Dim i as Integer line from it's current place to outside of all the subs in the userform module.
See attached.

BSB

[AlphaFrog]

To add to BSB's reply, you may want to put a Label control on the UserForm that indicates the row of the record that is displayed in the text boxes. You update that Label when you populate the textboxes...

Please Login or Register  to view this content.

[RoroBear]

BadlySpelledBuoy,

Your method worked beautifully!!! Again, I really appreciate the support and speedy turnaround on this one.

v/
rorobear

[BadlySpelledBuoy]

Happy I could help

BSB