How much text can be put into a message box
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 |
How much text can be put into a message box
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 |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com