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"

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