MsgBox Line Limit

[TFCJamieFay]

I'm trying to display a msg box with a section of text in. This passage is 10 paragraphs long over 36 lines with 1800 characters and when the code is ran it cuts off the last half. Is there a way to display this large passage of text in either a msg box or whatever with a button underneath to close it an return the user to the original form.

Many thanks,

Jay

 

[GlennUK]

Why not display a userform with 10 labels or textboxes, 1 for each paragraph?

 

[TFCJamieFay]

That's a good idea, but how do you show/hide a user form? Mine's called UserForm1.

Thanks,

Jay

 

[GlennUK]

UserForm1.Show to show it.

Have a command button on the form, with code of Me.Hide