MESSAGEBOX

[imported_unknown]

Is it possible when using a messagebox that the message is in the center and not all to the left? Hope someone can help me. Thanks.

 

[Joe Was]

The MsgBox does not accept the "xlCenter" property. To center you will need to pad your lines with spaces and returns, like:

Sub myMsg()
MsgBox " Nice!" & Chr(13) & " Work!"

End Sub

Hope this helps. JSW

P.S. The board may have removed the displayed spaces from the code above.
This message was edited by Joe Was on 2002-10-03 18:21

 

[ylijohe]

You mean like this?

Sub myMsg() 
MsgBox "                  Nice!                   " & Chr(13) & "                    Work!                        " 

End Sub 

 

[Joe Was]

Yes and no, your leading spaces yes, your trailing spaces no, adding trailing spaces just enlarges the box. JSW