Changing forecolor of certain words in Rich Text Box

[AlexanderBB]

How might this done please? Have tried various methods without success e.g.

With RichTextBox1
.Text = "<font color="green"> Welcome to BLAHG BLAH. </font>"
.Select(richTextBox1.TextLength - 4, 4)
End With

The Only Excel-specific instructions I could find were for RTB on Worksheet whereas mine is on a Userform. And the to-be colored text is not selected. It's intended as a heading.
Thanks for any help.

 

[Micron]

If the control contained "this is a test" then this should colour "is a" as red

With InkEdit1
    .SelStart = 5
    .SelLength = 4
    .SelColor = vbRed
    .SelLength = 0
End With

You would need an event that will trigger that code.

 

[6StringJazzer]

I don't seem to have this control. Where do I get it?

 

[Micron]

I believe its proper name is InkEdit control. You probably have that. Try Tools>more controls if it's not already in your toolbox.

 

[Fluff]

There used to be a RichTextbox, but it was disabled in (I think) 2003 for security reasons & was only available on 32bit versions of Excel.

 

[AlexanderBB]

I've Office 2010 and it's listed under Additional Controls - Microsoft Rich Textbox Control SP6 with Location
C:\WINDOWS\system32\RICHTX32.OCX. In Office 2019 the location is Location C:\WINDOWSKSysWOWE'Mrichtx32.ocx
But after much hunting I can find nothing on how it's used.
I had tried InkEdit and it was nearly ok, but you could not bold just some text, it affected everything.
I'm looking for some way to have text with headings colored/bold and remaining text black/regular.

 

[Micron]

but you could not bold just some text, it affected everything.

The order in which you format the font may be important. However, your post said nothing about bold. It was about forecolor.

 

[Micron]

Here is the red part bolded

 

[AlexanderBB]

I didn't mention bold as I believe a rich text box will do that, certainly the one in Access does (but I couldn't get the Excel one do anything except show plain text.)
What was the method you used for red bolded? This is with InkEdit?
Could you do this

Heading 1 (Red Bold)
Some plain text black
Heading 2 (Blue Bold)
some plain text black

etc...

 

[Micron]

Yes it is InkEdit but I don't know what you mean by the rest of that. Could you post an example of what you mean?