msgbox maximum character

[Novice_excel]

Greetings All,

I just realize that there is a maximum number of character a standard 'msgbox' command will handle.

Is there anyway to activate the scroll bar on the msgbox so the user can 'see' the rest of the information?

Thanks!

 

[JoeMo]

Greetings All,

I just realize that there is a maximum number of character a standard 'msgbox' command will handle.

Is there anyway to activate the scroll bar on the msgbox so the user can 'see' the rest of the information?

Thanks!

In Excel 2003 the max character count for a msgbox is 1024. Not sure if that's changed for 2007 and/or 2010. In any case, if you need to exceed the limit consider a user form or break the message into parts and use more than one msgbox.

 

[shg]

Or create a simple userform with a label to use in lieu of msgbox.

 

[Novice_excel]

Hello SHG,

Can I use a variable with the userform's label?

Also, if there are too many characters, will it introduce a scroll bar on the side?

Thanks!

 

[shg]

You can put anything you want in a label or a textbox.

No scroll bar with a label, but yes, if you use a textbox.