Regexp help, I need a regex that accept a string of (+) or (-) followed by a number

[danitouffaha]

I want to write a regular expression in vba that accepts 1,2 or 3 (-) or 1,2 or 3 (+) and series of digits(0-9), and it can repeat
so for example +++5+2-10+6 is accepted
++++5 is not accepted because there 4 (+) as well as ----10+2 not accepted because there are 4 (-)
I have tried many regex that did not work

Sub Test_Pattern()
Dim Str As String
Dim regexObject As RegExp
Set regexObject = New RegExp
With regexObject
   'checks if any word in our string start with an alphabet between W and Z
   .pattern = "[\+|\+\+|\+\+\+][0-9]{1,}"
End With
Str = "++++55"
'A message box displays true because we have a word starting with W ‘World’
MsgBox regexObject.test(Str)
End Sub

I think it should be easy but couldnt find anything to help me resolve it

Thanks

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

When posting vba code in the forum, please use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details. I have added the tags for you this time.

If the acceptable strings consist of nothing other than 1 to 3 + signs or 1 to 3 - signs followed by 1 or more digits (all of that possibly repeated) then try this pattern line.

.Pattern = "^((\+{1,3}|\-{1,3})\d+)+$"

 

[danitouffaha]

"^((\+{1,3}|\-{1,3})\d+)+$"

Thanks a lot Peter, it worked!!!
I will take your suggestions into consideration next time I post

 

[Peter_SSs]

You're welcome. Thanks for the follow-up,