Multiple formats inside single text box (activex)

[CodyMartin]

Hello again.

I'm having trouble keeping the formatting correctly in a text box through VBA. I'm sure this is something simple, but I'm the intern that got stuck with trying to program for the break since they know I've taken classes on the subject. I've been able to figure out a lot, which I owe a great amount of thanks (THANK YOU!) to this forum and the handy search function. However, I couldn't find any pertinent information regarding this topic.

End goal: To have the first word of a text box larger, underlined, and bolded.

Problem: It only formats it Calibri at 24 point with no special formatting as indicated in the code.

Please Login or Register  to view this content.

Thank you for looking,

Cody Martin

[Leith Ross]

Hello CodyMartin,

A VBA TextBox control can have only 1 formatted font and font color applied to the text. What you are describing is a RTF (Rich Text Format) control which VBA doesn't support.

Sincerely,
Leith Ross

[bhofsetz]

Cody,

How is your textbox added to your sheet. Is it a drawing object or an OLEObject?
It looks like you reference it as

Sheet6.txtMidCon

In my limited experience with textboxes I usually have to reference a drawing object textobx as a shape and the various objects within the shape accordingly:

i.e.

Please Login or Register  to view this content.

have you tried recording a macro and making the desired changes to your textbox to see the code?

[CodyMartin]

I switched from an Active X control to just a basic form text box and it seems to be working now... since I found some random code that was using Selection.xxxxx later in my code (I meant to take it out, I guess that's what trying to code all day does to you!) that was resetting my formatting for it also. Thank you for the help everyone -- knowing that the Active X text box doesn't support RTF will be useful information.

Thank you,

Cody Martin