Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Text
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. -- Regards, Tom Ogilvy "Benz" wrote: 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. |
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 |