Format Text

[Guest]

Sorry I'm reposting this from yesterday to see if I can get a reply/

Hi,

I have a mult-line text box with paragraphs of data. I was wondering if
there is a code that would leave all original text as is, but then all newly
entered text Bold and red. Ive been trying to change the range to the
slected textbox and then

.Name = "Arial"
.FontStyle = "Bold"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleSingle
.ColorIndex = 3
End With

But thats not working out to well. I would appreciated any help.

Thank you.

~Ben Z.

 

[Guest]

Thanks Tom.

control toolbox toolbar textboxes do not support Rich text formatting as you
describe.

If the textbox is on a worksheet, use a textbox from the drawing toolbar.

then Record a macro while you format a portion of the text in the textbox.