Text Box colours

[kirkm]

I'm sure you're limited to one text colour per text box?
Or is there some very clever way to do this?
Thanks - Kirk

 

[Rick Rothstein]

Where is the TextBox located... on a UserForm or the Worksheet? Also, can we
assume you want to control the text and color from code?

 

[kirkm]

Where is the TextBox located... on a UserForm or the Worksheet? Also, can we
assume you want to control the text and color from code?

Hi Rick,
I made a mistake - it's not a text box, but a label.
Yes, from code.

The label is in a Frame and I've been experimenting with one label per
line to get some control over the colour and font attributes, but I
think it's too big a mission.

Thanks - Kirk