Ensure telephone number is entered properly

[drdre77]

Hi Everyone,

O.k. I haven't played with excel in a while, trying to remember some things here... basically I want to create a customer file. What I want is my admin to click on a button, which I created already.. and of course have the information needed in order pop up so that she can type it in. But, I want to fool proof it.. so when that button gets clicked, First thing comes up is Customer phone number, I want it so that if the telephone number is entered correctly... either xxx-xxx-xxxx or simply 10 digits xxxxxxxxxx that the next question pops up... Name, then Address, Then Email, and so on and so on.... If she made a mistake entering a phone number such as there's a charater in there, or 1 more or less number, I would like it to loop back and say basically... NOPE, please enter the Telephone number... until it's entered right.
Can that be done? lol
I hope so! I tried and can't do it...
Thanks
DrDre77

 

[than_gold]

Try with this:

[/COLOR][COLOR=#333333]TextBox1.Value = Format(TextBox1.Value, "#,###")[/COLOR][COLOR=#333333]

 

[István Hirsch]

Enter this as a validation formula then check with several strings if it is bullproof:

=OR((AND(LEN(A2)=12,SUMPRODUCT(MID("999099909999",ROW($1:$12),1)*ISNUMBER(0+MID(A2,ROW($1:$12),1)))+SUMPRODUCT(MID("000100010000",ROW($1:$12),1)*(MID(A2,ROW($1:$12),1)="-"))=92)),AND(LEN(A2)=10,SUMPRODUCT(0+ISNUMBER(0+MID(A2,ROW($1:$10),1)))=10))