chris01395,
So here's what I found. When you click the update button it runs fine for 1 loop, but then the Listbox1_Click event runs which sets all the list boxes at the bottom back to what is on the sheet. I'm not quite sure why but it does. So after the first loop, the listbox values go back to what is already on the sheet, so the values on the sheet are set to the list box values after they have been changed back to the sheet's values. If that makes sense lol
Anyway, I tried setting the EnableEvents property of the application to false so that wouldn't happen but that didn't work.. not sure why there either.. So here's what I did:
1. In the module I created a public variable.. (Public StopCode as boolean) I don't know if you need the code in that module, so if you don't need that code you don't have to have it, but you can't get rid of that variable.
2. I changed the Update button code to this:
The error handler is just in case something were to happen your listbox1 click event will still work.
Then at the top of the Listbox_Click event I added this line:
If StopCode = True then Exit sub
That stops the ListBox1_Click event from running until StopCode is set back to False, which happens at the end of the Update button code.
It works good. I uploaded the file with the fixes I mentioned.
I hope it solves your problem. If it does, I hope you will add to my reputation because I just started helping out here.. lol
If you have questions concerning this same problem, please let me know!
Bookmarks