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!
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Darren Bartrup

Well-known Member
Joined
Mar 13, 2006
Messages
1,295
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,370
Members
410,679
Latest member
rolandbianco
Top