Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Won't work in a standard message box. It has built in font that cannot be
changed without accessing the source code for the MsgBox function, and that is beyound the scope of VBA. "RDFischer" wrote: JMH, There is a VBA function that permits addressing individual characters... With Worksheets("Sheet1").Range("A1") .Value = "abcdefg" .Characters(3, 1).Font.Bold = True End With You could construct a string and copy it to a cell, then address individual characters as shown using the Characters function which enables one to set size, font, color, bold, underline, etc. RDF "JMH" wrote in message ... I have a message box created, but can't seem to set the font or formatting of different parts of the text. eg. I want the message to read: Don't forget {in bold} 1. wash your face {in standard font} 2. clean your teeth {in standard font} I can get the line breaks etc, but not the changing formatting. Any suggestions? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format Font Vs Normal Font | Excel Discussion (Misc queries) | |||
How format partially one text cell for font, etc., but not whole c | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
How to sent for cell: font size=7,text format in VBA | Excel Discussion (Misc queries) | |||
Windows message text font | Excel Programming |