ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text Box colours (https://www.excelbanter.com/excel-programming/419812-text-box-colours.html)

kirkm[_8_]

Text Box colours
 

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

Text Box colours
 
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?

--
Rick (MVP - Excel)


"kirkm" wrote in message ...

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



kirkm[_8_]

Text Box colours
 
On Mon, 10 Nov 2008 21:46:41 -0500, "Rick Rothstein"
wrote:

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


All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com