EXCEL UDF that returns a String of multiple string objects. Possible to color font?

Hi there,

I have a udf that returns a string to the cell. The string is made up of multiple string "objects". What I am wondering is if I can set the font color of certain objects so that when the final string is built and returned, the font of those portions is set.

Ex. of simple idea (this is not actually my code, just a way to illustrate. I realize there is no point to this UDF):

Function StringReturn (Str1 as String, Str2 as String, Str3 as String) as String


StringReturn = Str1 & Str2 & Str3


End Function

Now what if I wanted Str1 and Str3 to be blue, and Str2 to be red for example. So that when the UDF calculates it would return: Str1Str2Str3

Thanks!

Re: EXCEL UDF that returns a String of multiple string objects. Possible to color fon

Alright then, thansks Norie! saves me the time trying