VBA Highlight numbers only after or before specific words help

		Microsoft Office Forums > Microsoft Word > Word VBA
VBA Highlight numbers only after or before specific words help

FAQ

Thread Tools

Display Modes

08-05-2022, 01:57 AM

Shelley Lou Shelley Lou is offline

Windows 10 VBA Highlight numbers only after or before specific words help

Office 2016

Expert

Join Date: Dec 2020

Posts: 259

VBA Highlight numbers only after or before specific words help

Hi Andrew, I did try the same thing before posting but it didn't work

Code:

.Text = "(" & arrA(i) & ")([ \^s])([A-Z0-9.]{1,})"

Maybe it needs an IF...Then - code below is taken from an auto numbering macro I have and wondering if it could be adapted for my highlight purpose perhaps

Code:

iNum = UBound(Split(.text, "."))
If IsNumeric(Split(.text, ".")(UBound(Split(.text, ".")))) Then iNum = iNum + 1
If iNum < 10 Then
.text = vbNullString

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Highlight numbers after a specific word in numbered list	liblikas90	Word VBA	3	02-27-2019 03:52 AM
How to highlight lines containing specific words	SixStringSW	Word VBA	4	06-03-2018 03:57 PM
How to find (highlight) two and more words in a list of 75k single words in Word 2010	Usora	Word	8	05-29-2018 03:34 AM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
VBA to highlight words if used too much	aolszewski	Word VBA	3	11-23-2013 02:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 AM.