Because nobody is perfect, I need a code to edit information previously entered on a user form.
I created a user form which saves input on a worksheet.
Information previously input via the form is reviewed by staff by use of a listbox with textboxes displaying the other columns in the selected row. They scroll through the first column of information looking for a row that displays a desired part#, and then the textboxes display the other information in the chosen row.
Staff do find mistakes and they need to edit this info. Since textboxes are editable, I don't see why this isn't possible.
I've been very frustrated creating code to save these edits. The furthest I've gotten is to be able to re-write the first cell in the chosen row of the listbox but saving to the cells in the next columns over has escaped me. I've tried with listindex, listcount, listrows...
P.S. my code is on my home computer - I'm at work - I worked on it all weekend :-(
Bookmarks