Formatting a Message Box

[TamsinL]

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.

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!

 

[Krishnakumar]

Hi,

See: http://www.mrexcel.com/board2/viewtopic.php?t=236163&highlight=

 

[Darren Bartrup]

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]

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