Macroni and cheese
New Member
- Joined
- Nov 23, 2017
- Messages
- 4
Hi all!
I'm creating a data entry user form in VBA which allow the company to input/modify/remove staff members.
Each staff member has a unique ID number.
Can someone help me with a code that searches through the existing data (once they have left that textbox in the user form)to identify if the unique ID is due to be duplicated?
I'm then hoping for a pop up box to prompt to ask the user if they want to continue (Y/N) and an option to take the user to the existing Unique ID number.
Userform = AddPerson
Worksheet = Sheet1
Textbox = Staffno
Thanks in advance!!
I'm creating a data entry user form in VBA which allow the company to input/modify/remove staff members.
Each staff member has a unique ID number.
Can someone help me with a code that searches through the existing data (once they have left that textbox in the user form)to identify if the unique ID is due to be duplicated?
I'm then hoping for a pop up box to prompt to ask the user if they want to continue (Y/N) and an option to take the user to the existing Unique ID number.
Userform = AddPerson
Worksheet = Sheet1
Textbox = Staffno
Thanks in advance!!