RegEx Object Error

[duckboy1981]

Hi all,

I am using a simple Regular Expression to check the contents of a Text Box on a user form but it is all of a sudden throwing up and error -

Run-time error '5021':

Application-defined or object-defined error.

This is the code I use for the call -

Please Login or Register  to view this content.

and this is the function for the RegEx -

Please Login or Register  to view this content.

The thing that has baffeled me is that this was working, and has been for a while, and then all of a sudden it started throwing up the error every time. I have checked everything I can think of that could cause an error like this but I am drawing a blank.

Any help is greatly appriciated.
Thanks.

[Chippy]

I found that the error only occurs with the second regex pattern, i.e. when TextType <> "Special". It looks like the "-&" part is being interpreted as a range, so you need to escape the hyphen to prevent this, as shown in the code below.

Also, when posting a problem try to make it easily reproducible for people to help you by including a test subroutine which simply calls the function in question with the correct data type (a string), rather than all the superfluous code for your call.

Please Login or Register  to view this content.

[shg]

... or just make the hyphen the last character:

Please Login or Register  to view this content.

[Leith Ross]

Hello duckboy1981,

It isn't clear to me how this code ever worked correctly. From the post I gather you want to look for any character that isn't part of the pattern. This will will do that. If any character is not part of the valid characters specified, it will be considered an invalid entry.

Please Login or Register  to view this content.

[duckboy1981]

Thanks guys, thats sorted now.