Format all new text
 

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.