Duplicate entries

[Streng]

I have a piece of code shown below.
I need to change it slightly but need help to do it.
I need it to display the message if findstring has been found more than once (i.e Twice)
Hope someone can help

Please Login or Register  to view this content.

[blane245]

If you test Rng.Count=2 that should do the trick. If the find can be anything greater than 1 occurrence, the Rng.Count>=1 wil work as a test.

[royUK]

It looks like your code currently searches for an entry in a textbox and displays a message if that entry already exists in Column A. Is that not what you are asking for?

[Streng]

Thanks for reply

The routine is for a textbox exit, it is correct that this displays a message if the entry already exists already in column A.

But, i would like this message to come up if the entry in the textbox exists twice in column A.

[Leith Ross]

Hello Streng,

The code will now display the dialog if there is more than one occurrence of the TextBox value.

Please Login or Register  to view this content.

[shg]

Or perhaps ...

Please Login or Register  to view this content.

[Streng]

Sorted thanks very much for help,
How do you make the thread 'SOLVED' or is that up to someone else