I have a XL spread sheet which i have created at work its very simple I only use it to input data for work which receive.

What I need help with is when I enter a address in on a line I want the spread sheet to alert me if i type the same address in again later in the spread sheet.

Help with this would be very much appreciated.

Tony

You can use the selection change even to check the user entry and ignore the text if already found


Private Sub Worksheet_SelectionChange(ByVal Target As Range)

 ' Loop thru the entire contents to check for address
 For i = 1 To Cells.SpecialCells(xlCellTypeLastCell).Row
    ' your code
    If addressfound Then
        MsgBox "Address exist!!!"
        ActiveCell.Value = vbNullString
    End If
 Next i

End Sub

Cheers
Shasur

http://www.vbadud.blogspot.com