'VBA Printing Text in one Cell with multiple Colors

I want to print some text in one cell with multiple colors:

Sheet1.Cells(1,1) = "Standard Text in Black" & Sheet2.Cells(1,1)

I would like the item in sheet 2 to stand out and be a different color is there anyway of doing that, that's still in the same cell?

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source