Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is

by Merrill Kuske (2 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 7^th May 2004
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is drawn from cell e3. Var1 = cell e3.

Rate Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is



Dim Var1 As Range
Set Var1 = ThisWorkbook.Worksheets("InfoSheet").Range("e3")
Set foundCell = ThisWorkbook.Worksheets("Pending").Columns("A").Find(Var1)
If foundCell Is Nothing Then
    MoveToLog     ‘Next Record or move to next subroutine
Else
    MsgBox "This appears to be a duplicate request. Please review pending list for possible duplicate entry in cell " & foundCell.Address
End If
End Sub

Download this snippet Add to My Saved Code

Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is Comments

No comments have been posted about Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is. Why not be the first to post a comment about Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is.

Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is

Excel 2000 Check for duplicate entry based on other cell... In this instance the duplicate entry is Comments

Post your comment

Difficulty