f2e4
08-04-2008, 06:15 AM
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?
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?