Sleeper: Check CC validation (in excel).

**ermis1975** · 09-28-2005, 05:31 AM

I have a column with card numbers...I want to check if are valid.(VISA, AMEX)

**Bob Phillips** · 09-28-2005, 05:41 AM

There is an explanation and an example at http://www.beachnet.com/~hstiles/cardtype.html

**ermis1975** · 09-28-2005, 05:56 AM

thanks...but I want to check numbers without typing each one in the cell.

**Bob Phillips** · 09-28-2005, 06:25 AM

Originally Posted by ermis1975

thanks...but I want to check numbers without typing each one in the cell.

But it demonstrates that with the weighting lookup table, the MID functions, the SUM, and then the MOD.

**ermis1975** · 09-28-2005, 08:00 AM

ok...thanks!!

I found it!!!

**ermis1975** · 09-28-2005, 11:47 AM

Little more help...
I want to insert a vba code and call the function from a cell behind the card. A have a lot of cards to validate.

Thanks

**Bob Phillips** · 09-28-2005, 12:58 PM

Originally Posted by ermis1975

Little more help...
I want to insert a vba code and call the function from a cell behind the card. A have a lot of cards to validate.

Thanks

can you explain what you mean by '... insert a vba code ...' and '... call from a cell behind the card ...'?

**ermis1975** · 09-28-2005, 01:43 PM

Sorry...
I have a list of cards in one column (A). In column (B) I want to validate tham.
Thanks..

Thread: Sleeper: Check CC validation (in excel).