Format font of text in a message box
 

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.

Format font of text in a message box
 

Sorry, that cannot be done in the standard message box. However, you can
create a form with a label on it and format the text of the label very
easily. Then use the UserForm.Show method to display the label as a pop up
message.

"JMH" wrote:

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.

Format font of text in a message box
 

Ok, thanks for the info (and the quick response).

"JLGWhiz" wrote:

Sorry, that cannot be done in the standard message box. However, you can
create a form with a label on it and format the text of the label very
easily. Then use the UserForm.Show method to display the label as a pop up
message.

"JMH" wrote:

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.

Format font of text in a message box
 

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.

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.