Help with MsgBox Please

[JBShandrew]

I'm just learning VBA, can some one please show me how to size a message box using VBA in Excel 2007?

Thank you in advance!

Sincerely,

J.B.

 

[JackDanIce]

I don't think you can, it autosizes to whatever information is passed to it

 

[JBShandrew]

The phrases that I use get cut off. Any ideas on how I can have all of my words display?

 

[RSXchin]

a message box can only hold 1070-ish characters.

but if you want to make a multiline msgbox....

msgbox("this is the first line" & vbnewline & _
           "this is the second line")