View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Visual Basic/Excel Changing font olor index in part of a string

hi,
on a play sheet i have, i just color the Changcolors()
part of the sub below to blue. the word sub remain black.
if i understand what you want, the code below with do it.
(tested).
Sub changecolors()
Range("H19").Select
With ActiveCell.Characters(Start:=1, Length:=4).Font
.ColorIndex = xlAutomatic
End With
With ActiveCell.Characters(Start:=5, Length:=14).Font
.ColorIndex = 5
End With
End Sub

-----Original 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.
.