Hi there,
I'm trying to get my userform interface to:
When I enter the information and press 'OK', before it records the information into the spreadsheet, it will search the rows in the spreadsheet and see if the exact same data has already been entered.
If the data has been entered a message box will appear stating "Duplicate Entry. Userform already exists. Proceed anyway, yes or no?"
Here is the userform code:
Please Login or Register to view this content.
Thanks!
You could add this section of code.
You also might want to change (or omit) the OR branch to avoid checking common duplicate fields, like Departmet, and only check the unique ones, like Name. If partial duplicates are expected, then that whole branch should be omitted.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi,
Thanks for your reply.
I try to enter the code however I always get the error of :
"End with without with" - I can't seem to figure out where to correct it.
Thanks
Should be like this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks to both of you.
Works perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks