Good afternoon,
Hope you get to help me on this one once again.
I'm trying to transfer items between two listboxes, however here is the trick: I need one button to transfer the item from list 1 to list 2, but not to change the data in the source sheet. So if I want to cancel the transfer, I only need to close the form. If I choose to confirm the transfer however, there is a save button to confirm and change the data in the source sheet.
My approach was to create a temporary sheet, that copies all the data from the source upon form activation, so if I hit cancel, the original data isn't affected. If I hit save, it copies the data from the temporary sheet to the source sheet.
However I think there might be a simpler way to do it. Any ideas?
Hope I made myself clear.
Hope you get to help me on this one once again.
I'm trying to transfer items between two listboxes, however here is the trick: I need one button to transfer the item from list 1 to list 2, but not to change the data in the source sheet. So if I want to cancel the transfer, I only need to close the form. If I choose to confirm the transfer however, there is a save button to confirm and change the data in the source sheet.
My approach was to create a temporary sheet, that copies all the data from the source upon form activation, so if I hit cancel, the original data isn't affected. If I hit save, it copies the data from the temporary sheet to the source sheet.
However I think there might be a simpler way to do it. Any ideas?
Hope I made myself clear.
