Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
message box text | Excel Worksheet Functions | |||
Flashing Text or message | Excel Programming | |||
Flashing Text or message | Excel Programming | |||
Centering the text in a message box | Excel Programming | |||
Centering the text in a message box | Excel Programming |