Hi,
i want atribute color of a part of a text string.
Exemple:
Range("C" & myRow).Value = "Parcial payment" & vbCrLf & myText
the "Parcial Paymente" in RED
Thanks.
Hi,
i want atribute color of a part of a text string.
Exemple:
Range("C" & myRow).Value = "Parcial payment" & vbCrLf & myText
the "Parcial Paymente" in RED
Thanks.
See this example: https://docs.microsoft.com/en-us/off...nge.characters
And this: https://docs.microsoft.com/en-us/off...cel.font.color
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Something like this...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks