Thanks Dave O,
I was almost there. I figured out how to fix the 2 and four number combo's,
just filled the series as they were 6 numbers.

I've just created a sheet were they can fill the numbers and get their
returned results. Put the data on another sheet and hid that sheet.

Thanks for the guidance.

"Tim" wrote:

I am trying to create a simple little program for our employees to check
credit card numbers and return which Credit Card company it belongs to.
My thought was to have a simple user form 'popup' stating, "Please enter
Credit Card Number here", a box to put the numbers in. Once they enter the
card number click the button and have it return a statement, "This is a ABC -
Master Card, contact number is (800) 555-1234"

The lookup would compare the first 6 numbers (although a few only do the
first 2 or 5) of the credit card entered, to a list in column A in Sheet1.
The Credit Card company names are in column B and the phone numbers are in
column C.

Can anyone point me in the right direction?

Thanks
Tim