Check if value exists in a range

[Bandito1]

Hi all,

I use a list where people add data in.

In column A from the worksheet "data" they add a code.

I would like that excel checks if that code exists in a range of existing codes that is on the sheet "products) in column A.
If it's a "new" code i would like to open a userform.

Anyone knows how i should do that?

 

[Fluff]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim Fnd As Range
   
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Value = "" Then Exit Sub
   If Target.Column = 1 Then
      Set Fnd = Sheets("Products").Range("A:A").Find(Target.Value, , , xlWhole, , , False, , False)
      If Fnd Is Nothing Then userform1.Show
   End If
End Sub

 

[Bandito1]

Perfect, thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback