PDA

View Full Version : [SOLVED] Formatting MsgBox



K. Georgiadis
06-11-2005, 09:33 AM
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
06-11-2005, 10:45 AM
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
06-11-2005, 11:14 AM
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
06-11-2005, 12:05 PM
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
06-11-2005, 12:10 PM
I think you can use the "Userform" toolbar in the vbe to do what you are describing. View-toolbars-Userform

Jacob Hilderbrand
06-11-2005, 12:29 PM
Me.Image1.ZOrder (0) 'Or 1

K. Georgiadis
06-11-2005, 12:31 PM
Thank you! I had done this once before but I couldn't remember how!

Jacob Hilderbrand
06-11-2005, 12:35 PM
You're Welcome :beerchug:

Take Care