Centring text within a msgbox

[benno87]

Hi,
I'm sure this is an easy easy fix but I can't find the solution anywhere. I'm trying to centre my text that goes within a msgbox. I'm thinking it's along the same lines as vbcrlf (to get a space to appear).

Your help is appreciated!!
Benno

[Andy Pope]

Here is a very old routine I wrote.
http://www.puremis.net/excel/Masters...enter_text.txt

You are better off using a userform with a label, which will automatically center text.