Change font of Msg Box displayed

[RAJESH1960]

Hello guys
When I run the code, a message box is displayed. Is it possible to change the font (size / Bold/ color) of the message displayed in a message box.? If so please share an example.

 

[My Aswer Is This]

Hello guys
When I run the code, a message box is displayed. Is it possible to change the font (size / Bold/ color) of the message displayed in a message box.? If so please share an example.

I would say "No". But then I have been proven wrong before. Most anything can be done but may require 100 lines of complicated code

 

[RAJESH1960]

I would say "No". But then I have been proven wrong before. Most anything can be done but may require 100 lines of complicated code

Means it is possible but complicated.

 

[My Aswer Is This]

Means it is possible but complicated.

I said Most anything. But I'm not saying it's possible. Wait and see maybe someone here has an answer

 

[RAJESH1960]

ADVERTISEMENT

I said Most anything. But I'm not saying it's possible. Wait and see maybe someone here has an answer

Ok Thanks.

 

[ScatmanKyle]

You can make a form and recreate what a button would look like. You should be able to customize your font if you do it that way.

 

[My Aswer Is This]

ADVERTISEMENT

Excel Does have what is know as a Userform.

Which you could create and put a message On and color things the way you q

You can make a form and recreate what a button would look like. You should be able to customize your font if you do it that way.

I assume you mean a Userform. I thought of that but requires a fair amount of knowledge how to build a userform.

 

[RAJESH1960]

I just watched a video that it is possible to customize a message box using userform. But I don't have any knowledge of user form.

 

[johnnyL]

If you want one example of how complicated this can get:

Customizing the Font and the BackColor of a UserForm's TitleBar

Hi all, I already wrote some code before for customizing the titlebar of userforms HERE and HERE. Unfortunately, both codes relied on subclassing the userform which poses problems of its own. Problems such as risks of crashing excel during IDE testings or during unhandled errors... Also...

www.mrexcel.com

Definitely not something a beginner should try to tackle.

 

[RAJESH1960]

If you want one example of how complicated this can get:

Customizing the Font and the BackColor of a UserForm's TitleBar

Hi all, I already wrote some code before for customizing the titlebar of userforms HERE and HERE. Unfortunately, both codes relied on subclassing the userform which poses problems of its own. Problems such as risks of crashing excel during IDE testings or during unhandled errors... Also...

www.mrexcel.com

Definitely not something a beginner should try to tackle.

. I assume that is a default setting which we can't edit or change by VBA