VBA Pop up/message box formatting

[BrianG86]

Hi

I have a message box that will come up once my Macro is complete. It's just there to let the user know that they can take the next step. Just for aesthetic purposes, I want the formatting to be better. Its currently all crammed in, I would like it to be on separate lines after each full stop and possibly to be centred in the message box.

Is this possible? This is my current code.

 MsgBox "The Macro is now complete.  Please email this to xxxl@xxx.com, and upload the CSV file to CaseBlocks.  Click OK to continue"

 

[VoG]

Try

MsgBox "The Macro is now complete." & vbCrLf & _
"Please email this to xxxl@xxx.com, and upload the CSV file to CaseBlocks." & vbCrLf & _
"Click OK to continue"

 

[BrianG86]

That's great, thanks for the quick reply.

Is there any way I could have this centred in the box, rather that left to right?

 

[VoG]

Sorry, no not with a standard Msgbox.

You could try padding with spaces at the left of the sentence - a bit trial and error.

 

[BrianG86]

Ok, I might give it a try, not that big a deal though

Thanks