Formatting MsgBox

[K. Georgiadis]

Several months ago I saw in Google Groups a comment that it is possible to format font type and font size in MsgBox text. Can you tell me how I can do that?

[Jacob Hilderbrand]

Try here:

http://www.h3.dion.ne.jp/~sakatsu/ktMsgBox_Series_English.htm

But you really should just make a User Form and format whatever you want.

[K. Georgiadis]

I'm not entirely clear how the ktMsgBox works and if it creates any problems, so I think I'll go with the UserForm option.

Thanks, DRJ.

[K. Georgiadis]

DRJ, if I insert a picture or a pattern to cover the entire area of the UserForm, is there a property that can send the picture to the back (similar to the Order commands in Excel's Draw toolbar)?

[lucas]

I think you can use the "Userform" toolbar in the vbe to do what you are describing. View-toolbars-Userform

[Jacob Hilderbrand]

Me.Image1.ZOrder (0) 'Or 1

[K. Georgiadis]

Thank you! I had done this once before but I couldn't remember how!

[Jacob Hilderbrand]

You're Welcome :beerchug:

Take Care