Bullet points within message box

M

MikeCM

Is there a simple way of putting in a set of bullet points into a
message box? I'm not worried about the format, they could be just
"- ".

The text I would like to display is along the following lines:

Blahhh blah blahhh, and blahh blah:

- bullet1
- bullet2
- bullet3



I have an automatic macro that runs when a particular sheet is
selected, along the following lines:

If Sh.Name = "xyz" Then

MsgBox "text here"

End If



The problem is that I can't convince it to put in the bulleted text.
Is there an easy way of doing this?
 
N

NickHK

Mike,
dim MsgText as string
MsgText="- bullet1" & vbnewline & "- bullet2" & vbnewline & "- bullet3"
MsgBox MsgText

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with InStr function 3
Bullet Points 4
Floating Text Box in Excel 2K3/2K7 3
bullet points 1
Vlookup result in a message box 10
Bolding Bullet Points 6
text box opens with bullet format 1
bullet points 1

Top