Message When Duplicate Item

zotee98 · Jul 25th 2006

I Need A Macro That Will Run When A Duplicate Item Number Appears In The Same Column. So For Instance If Aaa Exists In Column "b" And Someone Trys To Enter Aaa Again A Macro Will Run.

Thanks In Advance -

Wigi · Jul 25th 2006

Re: Message When Duplicate Item

Hi

Have A Look Over Here

Wigi

Dave Hawley · Jul 25th 2006

Re: Message When Duplicate Item

Right click on the sheet name tab of the needed Worksheet and choose View Code. In here paste the code below

Code

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target(1, 1).Column = 2 Then
        If WorksheetFunction.CountIf(Columns(2), Target) > 1 Then
           Run "MyMacro"
        End If
    End If
End Sub

Details on the Worksheet_Change Event here

Message When Duplicate Item

Participate now!

Share