Regular Expresions

[Anonymous]

This is probably a dumb question, but I'll ask it anyhow. Can you use
regular expressions in vba? I'd like to use something similar to the
following to verify a valid entry of a scale on a userform.

^[0-9]{1}=[0-9]{1}$|^[0-9]{1}=[0-9]{2}$|^[0-9]{1}=[0-9]{3}$

--
Tim Riley

[Anonymous]

yes,
add reference to Microsoft VBScript Regular Expressions 5.5

Set oRegExp = CreateObject("VBScript.RegExp")
oRegExp.IgnoreCase = True
oRegExp.Global = True
oRegExp.MultiLine = True
oRegExp.Pattern =
"^[0-9]{1}=[0-9]{1}$|^[0-9]{1}=[0-9]{2}$|^[0-9]{1}=[0-9]{3}$"

"Tim Riley" wrote in message
news:[email protected]...
>
> This is probably a dumb question, but I'll ask it anyhow. Can you use
> regular expressions in vba? I'd like to use something similar to the
> following to verify a valid entry of a scale on a userform.
>
> ^[0-9]{1}=[0-9]{1}$|^[0-9]{1}=[0-9]{2}$|^[0-9]{1}=[0-9]{3}$
>
> --
> Tim Riley
>
>

[Anonymous]

Awesome....Thank you.

--
Tim Riley



"Mark Propst" wrote in message
news:[email protected]...
> yes,
> add reference to Microsoft VBScript Regular Expressions 5.5
>
> Set oRegExp = CreateObject("VBScript.RegExp")
> oRegExp.IgnoreCase = True
> oRegExp.Global = True
> oRegExp.MultiLine = True
> oRegExp.Pattern =
> "^[0-9]{1}=[0-9]{1}$|^[0-9]{1}=[0-9]{2}$|^[0-9]{1}=[0-9]{3}$"
>
> "Tim Riley" wrote in message
> news:[email protected]...
> >
> > This is probably a dumb question, but I'll ask it anyhow. Can you use
> > regular expressions in vba? I'd like to use something similar to the
> > following to verify a valid entry of a scale on a userform.
> >
> > ^[0-9]{1}=[0-9]{1}$|^[0-9]{1}=[0-9]{2}$|^[0-9]{1}=[0-9]{3}$
> >
> > --
> > Tim Riley
> >
> >
>
>

[Anonymous]

I'll pass along the thanks to "ljb" who turned me on to regexp's
of course the settings:
> > oRegExp.IgnoreCase = True
> > oRegExp.Global = True
> > oRegExp.MultiLine = True
depend on what you want to do, they were just in the sample i cut and pasted
from

"Tim Riley" wrote in message
news:[email protected]...
> Awesome....Thank you.
>