Search results for query: *

Skip, I had already tried that and it works if I try to enter the duplicate value directly into a cell within that column. However it does not work when the information is entered through the user module that is listed out in the code above. It still allows any duplicate to be entered.

Skip, You suggested that I repost in this forum and I have taking your suggestion. I am looking to prevent the duplicates from ever being entered. If I go to Data and remove duplicates it would have to be done after the fact and not want I am trying to accomplish.

Trying to prevent the same item from being entered for the same customer more than once. So if customer A had an item called "Jars". I would not want them to be able to enter the item "Jars" again as a new item. Hope that helps. Thank you for the reply.

I am working with a user form that I need to check for duplicate, and prevent them from being entered. Any help would be greatly appreciated. Private Sub cmdAdd_Click() Dim lRow As Long Dim lPart As Long Dim ws As Worksheet Set ws = Worksheets("Items") 'find first empty row in database...

I am working with a user form that I need to check for duplicates and then return a message to the user if an item already exsists. Any help would be greatly appreciated. Private Sub cmdAdd_Click() Dim lRow As Long Dim lPart As Long Dim ws As Worksheet Set ws = Worksheets("Items") 'find...