hi, Im creating a excel booklist for our library and im using userform to insert new entry of books details. could someone help me to fix my code to search duplicate for ISBN, title and call number. If this 3 entry no duplicate found, then only create/insert new booklist entry. So far im only managed to get this work for ISBN only.
https://www.excelforum.com/attachmen...1&d=1580278127
Please Login or Register to view this content.
Last edited by amein; 01-29-2020 at 02:25 AM. Reason: add details
If you work with the textbox_exit event for each textbox, then you will know if the value exists right away.
Please Login or Register to view this content.
Thank you for your reply, I modified little bit and come out with this.Originally Posted by davesexcel
If you work with the textbox_exit event for each textbox, then you will know if the value exists right away.
Please Login or Register to view this content.
Attachment 660266Please Login or Register to view this content.
Then, now, I want to add a button so that once we found the duplicate, then we can click on that button and directly go to the cell of the duplicate data.
I try something like this but only works with 1 value which is Title. how to combine this code so that can work with ISBN and Call number too?
Or can we add into the first code for this purpose?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks