MsgBox question

  • Thread starter Thread starter gareth
  • Start date Start date
G

gareth

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
 
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
 
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
 
Back
Top