So what I'm looking for is a security measure to add into my existing code.

Example:

Input form:
2 comboboxes (1 for names / 1 for places)

Sheet1:

Stores all the inputs from these two comboboxes

Column A = names
Column B = places


Is anyone aware of any code that will check if a particular combination has already been entered e.g.

Say the following combination has been entered:

A B
John Paris

If this combination has been entered I want the code to display a msgbox saying Value already entered and then Exit Sub.


I have tried various versions of the find function but can't seem to get anything to work.

Any ideas?