text of different colours in a single textbox

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

Hi,

Is there a way to display text of different colours in a single textbox
? Thanks...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

single colour system for textboxes 1
TextBox Text 3
Excel How to change lines in graph to individual colours 0
Font color in userform controls. 1
colour format text when copied from text box 4
Changing the test of checkboxes (shapes) programmatically? 3
Return a string based on which Textbox is clicked 2
Count Conditional Formatting Colours - Excel 2003 4

Back
Top