MsgBox question

[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

 

[Chip Pearson]

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

 

[Mike Tomasura]

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