Format text using VBA

[Alan]

Is it possible to embolden part of the text held in a cell using VBA?

For example, if a cell contains two words " dog cat" is it possible to
change the font of "dog" to bold without changing the attributes of
"cat"?

Alan

 

[Bob Phillips]

With ActiveCell

.Characters(5, 3).Font.Bold = True
End With

 

[Alan]

    With ActiveCell

        .Characters(5, 3).Font.Bold = True
    End With

--
__________________________________
HTH

Bob








- Show quoted text -

Thanks Bob, that is a great help.