How to add bullet point in msgbox in vba code

Hi all

I'm try to add message box but has bullet points set out like

Have you check ?
• stores number
• stock levels
• part number

Thanks in advance

Shane

thanks to both of you works great legends

Hi guys,

I just want to tag onto this post. I am creating a dashboard and we need to give powerpoint presentations on this data every month. I am using vba to link the dashboard to a powerpoint presentation. I am having trouble figuring out how to take data from cells A1 to A18 and paste them in a textbox in power point and have each cells data show up under eachother with a bullet point. I have managed to find some code that will stack the cells now i just need bullet points.

Here is what i am looking for:

• A1
• A2
• A3

Here is the code i have for this slide so far.

Dim ppres As PowerPoint.Presentation
Dim ppslide As PowerPoint.Slide

Set ppslide = ppres.Slides(8)
ppslide.Select
Range("A2:A17").Copy
ppslide.Shapes(3).TextFrame.TextRange.PasteSpecial DataType:=ppPasteRTF

Thank you,

Zack

@zack43007.
Please read the forum rules. In this case pay attention to #2.
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.