Colour section of sentence using VBA.

[SEJTurner]

I'm using VBA/ combo boxes to fill in cells with different text depending on the selection made in the combo box.

The issue is that with one of the selections I need the last 3 words ij the cell to stand out, so they need be be a different colour and if possible bold. However the other words in the cell need to remain standard black and if other selections are made in combo box then full cell text must remain black.

Any suggestions on how I could do this?

Thanks

 

[kanadaaa]

Something like this:

Private Sub CommandButton1_Click()
    Range("A1") = ComboBox1
    If ComboBox1 = "format ABC" Then 'The value you want to colour and boldface
        With Range("A1").Characters(Len(Range("A1")) - 2, 3).Font
            .Color = vbRed
            .Bold = True
        End With
    End If
    Unload Me
End Sub