View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Benz Benz is offline
external usenet poster
 
Posts: 63
Default 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.