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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.