# Credit Card Validation (Luhn Formula)

Uses the Luhn formula to quickly validate a credit card. Basically all the digits except for the last one are summed together and the output is a single digit (0 to 9). This digit is compared with the last digit ensure a proper credit card number is entered (Does not actually confirm that is is a real number, just that it is likely to be one. Example: Entering "4000-0000-0000-0002" will pass the check, but "4000-0000-0000-0003" will not pass.)

**Original Author:** BrewGuru99

### Code

`Function CheckCC(CCNo)`

Dim i, w, x, y

y = 0

CCNo = Replace(Replace(Replace(CStr(CCNo), "-", ""), " ", ""), ".", "") 'Ensure proper format of the input

'Process digits from right to left, drop last digit if total length is even

w = 2 * (Len(CCNo) Mod 2)

For i = Len(CCNo) - 1 To 1 Step -1

x = Mid(CCNo, i, 1)

If IsNumeric(x) Then

Select Case (i Mod 2) + w

Case 0, 3 'Even Digit - Odd where total length is odd (eg. Visa vs. Amx)

y = y + CInt(x)

Case 1, 2 'Odd Digit - Even where total length is odd (eg. Visa vs. Amx)

x = CInt(x) * 2

If x > 9 Then

'Break the digits (eg. 19 becomes 1 + 9)

y = y + (x 10) + (x - 10)

Else

y = y + x

End If

End Select

End If

Next

'Return the 10's complement of the total

y = 10 - (y Mod 10)

If y > 9 Then y = 0

CheckCC = (CStr(y) = Right(CCNo, 1))

End Function

Loading Comments ...

## Comments

No comments have been added for this post.

*You must be logged in to make a comment.*