Is there any way to center the prompt in a MsgBox?

AFAIK, the only way is to add spaces to the beginning of the prompt.

You'll have to tweak the values:

MsgBox "Hello"
MsgBox String(40, " ") & "Hello"



In article ,
"Bill Oertell" wrote:

Is there any way to center the prompt in a MsgBox?

Hi,

I believe you can also use vbTab for spacing...

Rocke

--
Message posted from http://www.ExcelForum.com

MsgBox String(40, " ") & "Hello"

or MsgBox Space(40) & "Hello"

or MsgBox Space(40) & "Hello"

Oops, just tried it and it would in fact make the text string right
justified. Should be something like:

MsgBox Space(20) & "Hello" & Space(20)

Thanks. At least that's better than experimenting with: MsgBox(" Hello")

"Shatin" wrote in message
...
or MsgBox Space(40) & "Hello"

Oops, just tried it and it would in fact make the text string right
justified. Should be something like:

MsgBox Space(20) & "Hello" & Space(20)