How much text can be put into a message box

[Andrew]

Hello,
I'm using MsgBoxes in a program to help user's know how to operate the
spreadsheet. It seems that there is a limit to how much text I can
put into one message box. Does anyone know what that limit is, and
whether or not it can be changed?

thanks

 

[Jim Cone]

Test it yourself; run this code and note that the Z appears at the end.
Run it again after increasing the number of characters from 1022 to 1023...
'--
Sub TestMsgBox()
Dim strVeryLong As String
strVeryLong = String$(1022, "+") & "Z"
MsgBox strVeryLong
End Sub
--
Jim Cone
Portland, Oregon USA



"Andrew"
<[email protected]>
wrote in message
Hello,
I'm using MsgBoxes in a program to help user's know how to operate the
spreadsheet. It seems that there is a limit to how much text I can
put into one message box. Does anyone know what that limit is, and
whether or not it can be changed?
thanks