Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox question
I have a message box to display additions made to the
AutoCorrect list. It would appear that there is a maximum of characters or of size of the actual msgbox. Can anyone please confirm what are the limits of a msgbox. Also, is there any way to expand the box to allow more text? Many thanks. Gareth |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox question
Gareth,
The maximum length of the text in a message box is 1023 characters, and cannot be increased. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "gareth" wrote in message ... I have a message box to display additions made to the AutoCorrect list. It would appear that there is a maximum of characters or of size of the actual msgbox. Can anyone please confirm what are the limits of a msgbox. Also, is there any way to expand the box to allow more text? Many thanks. Gareth |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox question
You can create a userForm and put a textbox on the form.
A textbox will hold more characters then a msgbox. To call the userform use this command userform1.Show To close it use this command userform1.Hide "gareth" wrote in message ... I have a message box to display additions made to the AutoCorrect list. It would appear that there is a maximum of characters or of size of the actual msgbox. Can anyone please confirm what are the limits of a msgbox. Also, is there any way to expand the box to allow more text? Many thanks. Gareth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msgbox question | Excel Discussion (Misc queries) | |||
msgbox | Excel Discussion (Misc queries) | |||
Msgbox | Excel Worksheet Functions | |||
Msgbox question | Excel Programming | |||
MsgBox Question | Excel Programming |