Microsoft Office Forums - View Single Post - [Solved] VBA highlight if value less than 10

Thread: [Solved] VBA highlight if value less than 10

View Single Post

Old

02-27-2024, 01:47 PM

vivka

vivka is offline

vivka uses Windows 7 64bit

Windows 7 64bit vivka uses Office 2016

vivka uses Office 2016

Office 2016

Expert

Join Date: Jul 2023

Posts: 302

vivka is on a distinguished road

Default

Hi! I didn't test it but hopefully it will work:

Code:

.text = " [0-9] " & Split(StrFndB, ",")(i)

or

Code:

.text = "<[0-9] " & Split(StrFndB, ",")(i)

Reply With Quote