Develop One Single TextBox/UserForm with diferent Fonts and Color. Is it doable?

[actjfc]

Is there a way to insert a kind of “TextBox” in an UseForm where I can use different Fonts and Colors within the same TextBox/UserForm. Something similar to be writing in MS Word that allows us to use fonts and colors as we please.

I need to add to a Multipage UserForm some directions and other text. I need to use mostly Regular Arial, Arial Bold, and at least three colors, black, red, and blue in-between many paragraphs/lines/words.

Can it be done? Any ideas about how to do it?

Thanks!

 

[Jaafar Tribak]

Have you tried looking into the RichEdit Control ? It allows for formatting individual characters, words and paragraphs.

 

[Jaafar Tribak]

Also take a look at the InkEdit control which inherits frm the RichEdit control :
https://stackoverflow.com/questions...er-in-textbox-in-different-color-in-vba-excel

Edit:

Disable the inkMode Property of the Ink control when loading the UserForm:

Private Sub UserForm_Initialize()
    InkEdit1.InkMode = IEM_Disabled
End Sub

 

[actjfc]

Thanks! So, if I need some titles in Bold, and a few words in Red or Blue within a few paragraphs in a Form, then I need to develop a VBA code to show them as I need? Ok, let's assume I can do it, what about the final user. Does the final user needs the InkMode Property checked in his/her Excel in order to actually see the Bold, Red and Blue fonts? If so, maybe I can develop this kind of forms, but only if I can find a way to automatically check the InkMode Property programatically, otherwise the final users will not do it. Thanks!

 

[Jaafar Tribak]

Yes - you will need to do everything in code like is shown in the link I posted.

The other thing that is required is that the user must have the Ink Control installed and registered in their machine ..