storing account numbers

  • Thread starter Thread starter Cliff Myers
  • Start date Start date
C

Cliff Myers

Hi, my current workbook notifies the user if an invalid account has been
entered but I only have it check for 2 known invalid accounts. I noticed the
other day a user input account number 324 instead of 624, the 324 was
accepted because it wasn't one of the 2 known invalid accounts. I'm using
OR to check for the 2 invalid account numbers, but what I'm wanting to do
now is have if check for all known account numbers instead. I know I can
use "If cells(1,1).value = 625 OR cells(1,1).value = 612 OR etc.. but I
don't want to have to use 15 OR functions. Is there another way to store 10
account numbers instead?

Thanks,
 
Try using Data Validation from a List that provides a means to check valid
account numbers and provide user warnings.

Cheers
Nigel
 
Back
Top