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 vote348 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote330 views1 answer
Vb get ip address
VBA
3 votes375 views1 answer
Extract word in a text in excel
VBA
0 vote323 views1 answer
Vbs write file
VBA
0 vote344 views1 answer
Vba keep command window open
VBA
0 vote311 views1 answer
Vba select file in folder
VBA
1 vote331 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote324 views1 answer
Change whcih control a user has selected vb
VBA
0 vote323 views1 answer
Vbnet check if number is even or odd
VBA
0 vote304 views1 answer
Excel vba milliseconds
VBA