VBA Userform Textbox Font Change Specific Words

[ExcelGuyDude]

I've created a userform with a textbox inside with the following words:

"I'd like to BOLD and ITALICIZE these words."

How could I do that?

Thus far I've tried using InkEdit, but the issue I have there is when I attempt to edit the text within the InkEdit box, the InkEdit box disappears. It seems to be a common issue, so I'm trying to avoid the InkEdit Control.

 

[grawls44]

Hi,

You did not list the words but try this.

Private Sub TextBox1_Change()


If TextBox1 = "This" Then
    With TextBox1
        .Font.Bold = True
        .Font.Italic = True
    End With
End If


End Sub

If I am understanding what you want that should work.

Greg

 

[ExcelGuyDude]

Sorry, I would like the results to show up like this:

I'd like to BOLD and ITALICIZE these words, and make this word BIGGER."

So not having everything inside the textbox one font style, but individual words inside the textbox to be Bold, or Italics, or larger size.

 

[mikerickson]

Userform textboxes do not support Rich Text. All characters in a text box will have the same formatting.

 

[ExcelGuyDude]

What other control is available that would do that functionality?
(Aside from InkEdit. I'm certain there's something out there that isn't as bug-infested as InkEdit)

 

[mikerickson]

What other control is available that would do that functionality?

None of the standard user form controls support rich text.

Custom controls should be avoided if the workbook is going to be distributed to others, since the specialty controls may not be supported by the other machine.

Depending on your situation, you might want different text boxes, each with a different formatting.
Or perhaps different labels, if user entry into the box isn't desired.