Formatting a Message Box

TamsinL

New Member
Joined
Oct 5, 2006
Messages
10
I am trying to format a message box so that the text stands out more - preferably by making some bits bold or larger and increasing the line spacing.

My current code is as follows which puts the text onto 3 lines but it is not particularly clear to read.

Code:
MsgBox "Welcome to the GORD Impact Scale Data Analysis Tool." & vbCrLf & "To create a new patient record please click 'Create New Record'." & vbCrLf & "To find or amend an existing patient record please enter the unique Patient ID and click 'Search for Patient'."

I have tried just repeating & vbCrLf & to put extra lines in between the text but this throws up an error.

Anyone know how (if possible) I can make this statement bolder/larger/clearer?!

Thanks!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Darren Bartrup

Well-known Member
Joined
Mar 13, 2006
Messages
1,296
Office Version
  1. 365
Platform
  1. Windows
I use Chr(10) instead of vbCrLf which allows me to put in double spacing.

The only way I know of to create a formatted message would be to put it in a userform rather than a message box.
 

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
No, I don't believe you can, but there are add-ins available on the net that solve this problem for you.

Alternatively, you could design your own message box, using a userform
 

Forum statistics

Threads
1,141,931
Messages
5,709,406
Members
421,635
Latest member
mehdi hannechi

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