View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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.