regex 10 or 11 digit number code example
Example 1: regex numeric digits
' Needs reference "Microsoft VBScript Regular Expressions 5.5"
Dim rRegex As Object
Set rRegex = CreateObject("VBScript.RegExp")
rRegex.Pattern = "[0-9]{8,9}" ' 8 or 9 numbers
MsgBox rRegex.test("12345678") ' True
rRegex.Pattern = "[0-9]+" ' Numeric of any size
MsgBox rRegex.test("12345") ' True
Example 2: regex phone number 10 digit
^(\+\d{1,2}\s)?\(?\d{3}\)?[\s.-]?\d{3}[\s.-]?\d{4}$