PDA

View Full Version : 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
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
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..