Hello everyone,
I'm seeking assistance with a challenge I'm facing. I've been working on a UserForm to facilitate the insertion of items, and I've nearly achieved the desired functionality. However, I've encountered an unexpected behavior that I need help addressing.
Upon launching the form, filling in the required information, and clicking the Save button, the new item is correctly added in a new row on the worksheet, functioning as intended.
The issue arises when editing an existing item. While the modifications are saved to the same item, if I subsequently attempt to add a new item, the new information overwrites the previously edited item.
This behavior is not present when deleting an existing item.
I've tried examining the code to identify the cause of this behavior, but being super new to VBA, I'm struggling to pinpoint the issue. Could you please review the code and assist me in resolving this problem?
Attached the file I'm working on.
Thank you in advance for your help!
Bookmarks