Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |