Help needed with VBA Message Box

[PGD15]

Hi,

I have written a massively long string of if VBA code which will display text in a singular message box informing the user if the conditions are not satisfied. I have got this all work fine however, I cannot get all the text to display in the message box.

Is there a way of changing the heights and/or width of a VBA message box? Or another tool that I can use to display a larger message but still use the VBA code that I have written to to string together each part of the message.

 

[dmt32]

Hi,
If you look in the VBA helpfile you will see that the maximum length of prompt text is 1024 characters.
If your string length exceeds this you could consider creating your own custom msgbox with a userform - this can be adjusted to required size & have same response values returned as standard msgbox to work with your existing code.

Dave