Partial text colour in a string variable

[QuestionBaker]

I am generating a string variable by joining multiple values (some are taken from cells, others are just typed).
I am sending this string to a text box in power point.
Is it possible to partially colour the string (part green, part red, part blue)? I have an indentifier which can tell me what colour that subset of string has to be.
my string variable is being made somethig like this

str_var = ""
while till_next_cell_in_row_is_not_empty
    str_var = str_var & ws.Cells(i, j) & " has  " & ws.Cells(i, j+1) & " dogs."
    till_next_cell_in_row_is_not_empty = next cell in the row
Wend
send str_var to ppt text box

in each row, ws.Cells(i, j+2) will either be "R", "G" or "B", and based on the that value, that particular line should be coloured red, green or blue

 

[RoryA]

Variables don't have properties like colour. You would have to colour the characters in the shape in powerpoint, not the variable.