Verify Phone Number
~~~WOW, this accidenlty went to Access Newsgroup. Must not have been paying
attention this morning!!~~~~ Is there a method for verifying first if the data entered is a valid number, then if it's a valid phone number? By Valid phone number I mean is it 10 digits without any formatting EXAMPLE ##########? I think I can use IsNumeric for the first part, but can I pass a format to IsNumeric, if so how? Thank You |
Verify Phone Number
For a start:
Function IsPhone(n) As Boolean IsPhone = False If Application.IsNumber(n) Then If Len(n.Value) = 10 Then IsPhone = True End If End If End Function -- Gary''s Student "Striker" wrote: ~~~WOW, this accidenlty went to Access Newsgroup. Must not have been paying attention this morning!!~~~~ Is there a method for verifying first if the data entered is a valid number, then if it's a valid phone number? By Valid phone number I mean is it 10 digits without any formatting EXAMPLE ##########? I think I can use IsNumeric for the first part, but can I pass a format to IsNumeric, if so how? Thank You |
All times are GMT +1. The time now is 06:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com