Help creating a macro to identify values that have letters and numbers.

gmaxey · #1 08-07-2020, 08:30 AM

Graham,

What is/was your intent with the parts of your function that I've stetted out below:

Code:

Function TestRegExp(strFind As String, strText As String) As Boolean
Dim objRegExp As Object
'Dim objMatch As Object
'Dim colMatches As Object
    TestRegExp = False
    Set objRegExp = CreateObject("VBScript.RegExp")
    objRegExp.Pattern = strFind
    objRegExp.IgnoreCase = True
    objRegExp.Global = True
    If (objRegExp.Test(strText) = True) Then TestRegExp = True
'        Set colMatches = objRegExp.Execute(strText)
'        For Each objMatch In colMatches
'            TestRegExp = True
'            Exit For
'        Next
'    End If
    Set objRegExp = Nothing
'    Set colMatches = Nothing
'    Set objMatch = Nothing
End Function

gmayor · #2 08-07-2020, 08:59 PM

Quote:

Originally Posted by gmaxey

Graham,
What is/was your intent with the parts of your function that I've stetted out below:

It was part of a more comprehensive function and should have been deleted as it is not required here, though it wouldn't stop the function from working.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating your own Section Headings using Numbers and letters and linking to the TOC	rehahm	Word	4	10-07-2015 10:20 AM
Creating a TOC with sequential letters instead of page numbers at the right margin	shansen	Word	1	03-11-2014 12:43 PM
Look up cell values with mixed number and letters	Cardinal2	Excel	1	02-10-2013 01:40 AM
Captions mixing letters and numbers	trew	Word	7	11-21-2012 12:54 AM
Creating TOC with letters and numbers	tanababa	Word	1	04-28-2011 01:35 AM