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]

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

Would you please tell me what you use the message box for? A Message box is normally used for just a quick message to popup. Not sure why you want one with specific Font and font size and color and maybe more. But probable the only way to do this would be to build a Userform.
Have you ever written any Vba code yourself or you just get all your coding from forums like this? If you know how to write some Vba code yourself, you may want to look in to using a Userform. But if you have no real knowledge of writing Vba code trying to build a Userform and then writing the code to activate the Userform may be hard for you to do. To get every bit of help to build a Userform and use it from forums like this may be hard to do.

 

[RAJESH1960]

At the end of each code, a msg box is displayed like "Data is not entered", "Completed", etc., The font is too small for me to view. So, I thought if it is possible to increase the font size or at least make it bold so that it will be clearly visible. I post questions on forums for possibilities to customize my work according to my whims and fancies to make my work more interesting & finish faster and save time. The time saved helps me to think of new challenges and possibilities to over come them. The best part is I also enjoy learning both at the same time. The codes if shared with comments like JohnnyL's style, I try to create new apps with the help of those codes and have been 80 % successful in most of the cases. Rest I am lucky enough to complete it again with some help. I have learnt a lot from so many members from this wonderful forum and I really appreciate it.
As for Userform, I have heard about it but never tested or tried and I have no plans to learn about it in the near future.

Not sure why you want one with specific Font and font size

 

[Dan_W]

You could always try a simple implementation of the TaskDialog box, a kind of message box. It would/could look a little something like this:

I can post an example when I get home.

 

[RAJESH1960]

You could always try a simple implementation of the TaskDialog box, a kind of message box. It would/could look a little something like this:

View attachment 67309

I can post an example when I get home.

I think you all are not getting it. I actually want only the font to be bigger in the message box or at least bold. Color was just included in the option.

 

[My Aswer Is This]

I think you all are not getting it. I actually want only the font to be bigger in the message box or at least bold. Color was just included in the option.

I now understand. Wish I had an answer.

 

[RAJESH1960]

I now understand. Wish I had an answer.

It is ok man. I have one option left to solve this problem. Replace my specks with thick glasses.

 

[My Aswer Is This]

It is ok man. I have one option left to solve this problem. Replace my specks with thick glasses.

 

[johnnyL]

How about something like this:

 

[RAJESH1960]

Is that the result of using VBA or Userform.?

 

[My Aswer Is This]

How about something like this:

View attachment 67313

OK. So explain how using Vba you do this.