MsgBox Justification

[Bill Oertell]

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

 

[JE McGimpsey]

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"

 

[Rockee052]

Hi,

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

Rocke

 

[Shatin]

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

or MsgBox Space(40) & "Hello"

 

[Shatin]

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)

 

[Bill Oertell]

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