Format font of text in a message box
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.
|