Bold text in MsgBox

[The Idea Dude]

Is there any way to set some (not all) of the text to bold when using the MsgBox in VBA?

 

[Tom Urtis]

Partial formatting is not possible as far as I know, at least not without extensive API that would be more trouble than what a simple userform is worth. You can change the Windows system setting to font type, size, bold, etc, but that would still affect the entire font structure in all message boxes.

 

[The Idea Dude]

Cheers. I guess the challenge is out there to do it in VBA

 

[Tom Urtis]

If you mean to have VBA manipulate a message box so it displays more than one font on the same message box, like I said, it cannot be done. It'd be a Windows setting which means API, not VBA, the code for which I have not seen, and if it's do-able (which maybe it is using API), it wouldn't be worth the effort. A userform would be a better bet, much easier to use a label control for each font style, making it pretty much zero on the VBA challenge scale.

 

[DRJ]

Yeah, message boxes are just very basic. If you want anything more then displaying a simple message with and ok button or yes/no then you need a userform which can do practically anything you want.

 

[golf4]

Hi -

You may want to try the ktmsgbox option: http://www.mrexcel.com/board2/viewtopic.php?t=49750

I installed it on my machine at home, and it works really slick: bold text, different colors, warning chimes, etc.

HTH,

Golf