Excel Partial text font properties

I would like to be able to change the font color of a specific part of the text in a cell; In VBA you would do something like this   Public Sub changeColor() Range("A1").Characters(Start:=7,...