Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bullet points within message box
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bullet points within message box
Nick
Cool. Thanks for this. Mike NickHK wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bullet Points | Excel Worksheet Functions | |||
Bullet Points | Excel Worksheet Functions | |||
Bullet points | Excel Discussion (Misc queries) | |||
Bullet points | New Users to Excel | |||
bullet points | Excel Worksheet Functions |