How to change font colors of selected characters of a text string variable?

[ChetShannon]

I have seen many ways to change part of specific cells text color but I am looking to change the colors of select characters in a text string *variable*. I would think this would be faster than referencing a specific cell reference address and then changing the select characters in the cell text string.

So to be more clear I want to change the colors of characters in a text string variable. Can I do this?

SampleString ="this is the test string"
For example maybe I just want to change the font color of the word "test". There is no assigned cell position yet. Is this possible to do?

Thanks!
Chet

 

[Eric W]

It would be nice, but I don't believe it's possible. In VBA, a string value is just a collection of characters, no formatting information. You can change the color of part of a string in a cell because the cell has formatting information in addition to just the cell value.

 

[pgc01]

No, not the way you want.

If you'd like to include attributes in a string text variable you could use markup. You'd need to decode it when applying the string.

 

[ChetShannon]

Thanks to you both for your comments !

 

[oggiez]

This is a simple code that will work. It will only do the first instant but you could build off it to find each time that word is in a string.


Sub TextColor()

Dim MyText As String

MyText = "test"

Range("A1").Characters(InStr(1, Range("A1").Value2, MyText), Len(MyText)).Font.ColorIndex = 5

End Sub