Change font of Msg Box displayed

RAJESH1960

Well-known Member
Joined
Mar 26, 2020
Messages
1,769
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
18,983
Office Version
  1. 2013
Platform
  1. Windows
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
 

ScatmanKyle

Board Regular
Joined
Oct 26, 2015
Messages
65
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Jul 5, 2014
Messages
18,983
Office Version
  1. 2013
Platform
  1. Windows

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

Well-known Member
Joined
Mar 26, 2020
Messages
1,769
Office Version
  1. 2019
Platform
  1. Windows
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

Well-known Member
Joined
Nov 7, 2011
Messages
3,250
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
If you want one example of how complicated this can get:

Definitely not something a beginner should try to tackle.
 

RAJESH1960

Well-known Member
Joined
Mar 26, 2020
Messages
1,769
Office Version
  1. 2019
Platform
  1. Windows
If you want one example of how complicated this can get:

Definitely not something a beginner should try to tackle.
:unsure: 😲😞😥. I assume that is a default setting which we can't edit or change by VBA
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,158
Messages
5,857,702
Members
431,891
Latest member
shirazx3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top