Preventing Duplicates using VBA (code)

J

Jerry McCutchen

I have a sheet that has 8 digit (111-1111) telephone
numbers in colume B. I need to programatically prevent
anyone from entering duplicate values. I can do it using
the Data - Valadation and the COUNTIF function, but that
leaves the validation runction open so others can change
or delete it. I really would rather do it in VBA.

Help.

Thanks to all...
Jerry McCutchen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Preventing Duplicate Records 2
Excel vba code to match duplicates 4
How to completely remove duplicate rows in vba 2
How to compare two sheet using vba and remove duplicate content? 2
Counting Duplicates on two sheets 2
VBA for data validation in 3rd column does not run. I need help. 1
Copying Duplicate rows 1
can't see VBA code, although it's working 0

Top