Thread
:
Visual Basic/Excel Changing font olor index in part of a string
View Single Post
#
5
Posted to microsoft.public.excel.programming
charlie
external usenet poster
Posts: 2
Visual Basic/Excel Changing font olor index in part of a string
If the Cell is A1, then try the following code:
Range("A1").Characters(1, 2).Font.ColorIndex = 5
To change the color of the first 2 chars to blue
Al Gee <Al
wrote in message ...
I wish to change the font color index in part of a string (using visual
basic) in the same fashion that we can change a highlighted part of a string
in the editing bar.
VB
seems to require that the characters to have their font color index
changed have to be an entire selected cell.
Reply With Quote
charlie
View Public Profile
Find all posts by charlie