ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   text of different colours in a single textbox (https://www.excelbanter.com/excel-programming/309427-text-different-colours-single-textbox.html)

Adrian[_8_]

text of different colours in a single textbox
 
Hi,

Is there a way to display text of different colours in a single textbox
? Thanks...

--
Regards,
Adrian



Frank Kabel

text of different colours in a single textbox
 
Hi
aFAIK this is not possible

-----Original Message-----
Hi,

Is there a way to display text of different colours

in a single textbox
? Thanks...

--
Regards,
Adrian


.


Don Lloyd

text of different colours in a single textbox
 
Hi,

With a Text Box from the Drawing toolbar you can adapt the following

Sub Test()
ActiveSheet.Shapes("Text Box 3").Select
Selection.Characters.Text = "Good Morning it's Thursday"
With Selection
.Characters(1, 4).Font.ColorIndex = 3
.Characters(5, 12).Font.ColorIndex = 4
End With
End Sub

Regards,
Don

"Frank Kabel" wrote in message
...
Hi
aFAIK this is not possible

-----Original Message-----
Hi,

Is there a way to display text of different colours

in a single textbox
? Thanks...

--
Regards,
Adrian


.





All times are GMT +1. The time now is 02:52 AM.

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