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

Similar codes

0 vote142 views1 answer
Vba createparameter null
VBA
0 vote147 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote153 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote156 views1 answer
Vba variable number of arguments
VBA
5 votes159 views1 answer
Excel vba low word from Long Integer
VBA
1 vote156 views1 answer
Vbs run
VBA
12 votes268 views1 answer
Excel vba write string to text file
VBA
0 vote166 views1 answer
Vba round to 2 decimals
VBA
22 votes276 views1 answer
Xlvba check for folder
VBA
2 votes157 views1 answer
Excel vba check if string entirely alpha
VBA