Hello,
I have a userform that enters data in column A, I would like to get a msgbox response if the same entry has already been entered into column A, if this happens then the sheet resets itself and the user has to start again.
Please Login or Register to view this content.
Hopefully its a very simple solution but it has me stumped!
thanks reg
Last edited by reggie1000; 05-04-2012 at 05:46 AM.
Hi
Try this:
vba duplicate check via textbox .xlsm
Click *, if my suggestion helps you. Have a good day!!
Thanks jraj1106,
works great, thanks for your help.
reg
You are welcome ... Thanks for your feedback
Reggie,
Another method of doing it. (I was working on it, so thought of posting it, though you already have raj's solution).
Please Login or Register to view this content.
Last edited by arlu1201; 05-04-2012 at 05:56 AM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks