Color/Bold Text Displayed in Message Box

kingnutin

Board Regular
Joined
Jun 15, 2005
Messages
67
Is it possible to make it so that certain words in a message box are colored or bolded. I am trying to make a certain word stand out.

For an example consider a message box containing the text:
"Are you sure you want to UNLOCK this sheet?"

I would like the word "UNLOCK" to be the only word in the message box that is bolded and possibly green in color. All other text in the box would be plain non-bold and black in color, which would make the certain text stand out a little more. I would have another message box that would have the word "LOCK" bold and red in color.

Any ideas?
Thanks,
Clay Rose
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
There may be a way but I'm not aware of it.
If it's important to you, then I would consider a couple of small userforms instead of message boxes.
 
Upvote 0
Clay

This can be done with the standard message box but would involve using the Windows API.

I agree with HalfAce, create your own message box using a userform.
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

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
Back
Top