Message if duplicate found

Hello all,

I'm requesting again for any help: This is what I'm currently working:

My user is allowed to type certain numbers in Column A (range: A19 to 82). I need help for a macro that will alert the user that that value has been entered, then disallow entry of that duplicate value.

Any help is much appreciated, as always.

Thanks

WK

Hello WhiteKelso,

Since you are allowing only certain numbers, why not use Data Validation on the cell range? This would be easier and faster than writing a macro.

Sincerely,
Leith Ross

to a sheet module

Please Login or Register  to view this content.