Weasley0307
New Member
- Joined
- Dec 25, 2023
- Messages
- 6
- Office Version
- 2021
- Platform
- Windows
Hi. I have a userform for transfering the data into sheet1. But I want to make sure the userform does not save the data if the OC/SC No. textbox's value is duplicated with the existing data in column C of the sheets. As shown in picture below. I want to have a pop up msgbox saying that there is duplicated value with column C and it does not transfer the data, which means it will exit the private save data sub that i have.