Pop Up Window When Opening Workbook

I’m using the below VBA code I picked up from a different thread in order to have a pop up message every time I open a particular workbook.

Please Login or Register  to view this content.

My problem is that I can’t figure out how to make separate paragraphs, instead of one big paragraph. My end goal is to be able to have a nicely formatted list with space between each line. Something akin to…

1) Point number 1

2) Point number 2

3) Point number 3

4) Etc…

Would someone please tell me how to achieve this?

Thanks for your assistance!

Please Login or Register  to view this content.

That separates with a blank line between each. Only use 1 vbCrLf if the lines are to be together.

You will also have to split long lines otherwise the MsgBox just gets wider and wider

Please Login or Register  to view this content.

That is about the limit of the formatting you can apply to a MsgBox but I can guess the next question. The answer is 'No'.