![]() |
|
#11
|
||||
|
||||
|
You could use search to find numbers then expand to the word and use RegEx to see of the word has letters e.g. the following will find all the examples in this thread if they are in the main document text range
Code:
Sub Macro1()
Dim oRng As Range, oNum As Range
Set oRng = ActiveDocument.Range
With oRng.Find
Do While .Execute(findText:="[0-9]{1,}", MatchWildcards:=True)
Set oNum = oRng.Words(1)
If TestRegExp("[A-Z]", oNum.Text) = True Then
oNum.HighlightColorIndex = wdYellow
End If
oRng.Collapse 0
Loop
End With
End Sub
Function TestRegExp(strFind As String, strText As String) As Boolean
Dim objRegExp As Object
Dim objMatch As Object
Dim colMatches As Object
Set objRegExp = CreateObject("VBScript.RegExp")
objRegExp.Pattern = strFind
objRegExp.IgnoreCase = True
objRegExp.Global = True
If (objRegExp.Test(strText) = True) Then
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
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
| Tags |
| numeric, phonetic, word macros |
|
|
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 |