Extend the msgbox wider?

[doctortt]

Just a noob question. How do you extend the msgbox wider?

In addition, how do you change the color of the text in the msgbox? I searched through the VBA for dummies book, and I couldn't find anything about this.

Thanks a big time.

[Simon Lloyd]

You cannot change the message box properties, the message box will expand and contrat to accommodate the text you enter, to do what you want you need to create a userform to act as a messagebox then you can change all the properties you want :)

[doctortt]

Thanks.

But I can at least should be able to change the color of the text in the msgbo ("blah") right?

[Simon Lloyd]

Nope not right!, you would have to change the Windows settings for that and it would affect your whole computer.