View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Bullet points within message box

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

NickHK

"MikeCM" wrote in message
oups.com...
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?