Is there any addin which would enable this capability? I so often find
myself in positions where a regex would do just the trick.

Hi
as an example (validation of email addresses):
Public Function ValidateEmail(MailAddress As String) As Boolean
Dim oRegExp As Object
Set oRegExp = CreateObject("VBScript.RegExp")
With oRegExp
.Pattern = "^\w+((-\w+)|(\.\w+))*\@\w+((\.|-) \w+) *\.\w+$"
ValidateEmail = .Test(MailAddress)
End With
End Function


--
Regards
Frank Kabel
Frankfurt, Germany
"R Avery" schrieb im Newsbeitrag
...
Is there any addin which would enable this capability? I so often find
myself in positions where a regex would do just the trick.

http://msdn.microsoft.com/library/de...ting051099.asp

Can be called from VBA.

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
Is there any addin which would enable this capability? I so often find
myself in positions where a regex would do just the trick.

I'm sorry, I was not clear enough. I am familiar with using RegEx in VB
functions, but the VBE Search and Replace form supports wildcards, but
not RegEx. Is there a VBE Extensibility addin that enables RegEx search
and replace in the code editor. Typical examples would be: I have a
function with like 50 lines of var1 = cells(1,1).value, var2 =
cells(2,1).value, etc, and I would like to reverse the equality so that
it instead reads cells(1,1).value = var1, cells(2,1).value = var2.

As far as i know, things like this cannot be done using wildcards.




Tom Ogilvy wrote:
http://msdn.microsoft.com/library/de...ting051099.asp

Can be called from VBA.

I think you would need to export it to a text editor like Textpad and do it
there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R Avery" wrote in message
...
I'm sorry, I was not clear enough. I am familiar with using RegEx in VB
functions, but the VBE Search and Replace form supports wildcards, but
not RegEx. Is there a VBE Extensibility addin that enables RegEx search
and replace in the code editor. Typical examples would be: I have a
function with like 50 lines of var1 = cells(1,1).value, var2 =
cells(2,1).value, etc, and I would like to reverse the equality so that
it instead reads cells(1,1).value = var1, cells(2,1).value = var2.

As far as i know, things like this cannot be done using wildcards.




Tom Ogilvy wrote:

http://msdn.microsoft.com/library/de...ting051099.asp

Can be called from VBA.

I also missed RegEx sometimes.

Maybe Perl could be a solution when a workaround in VBA
seems to be too tedious:

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;214797

Regards,
Bernd

Sorry, didn't read the subject - just the text.

--
Regards,
Tom Ogilvy

"R Avery" wrote in message
...
I'm sorry, I was not clear enough. I am familiar with using RegEx in VB
functions, but the VBE Search and Replace form supports wildcards, but
not RegEx. Is there a VBE Extensibility addin that enables RegEx search
and replace in the code editor. Typical examples would be: I have a
function with like 50 lines of var1 = cells(1,1).value, var2 =
cells(2,1).value, etc, and I would like to reverse the equality so that
it instead reads cells(1,1).value = var1, cells(2,1).value = var2.

As far as i know, things like this cannot be done using wildcards.




Tom Ogilvy wrote:

http://msdn.microsoft.com/library/de...ting051099.asp

Can be called from VBA.