I have seen this answered before, and am sure that I have previously done this, but I can't find the code anywhere...

I want to format the text on message box displayed in Excel through VBA.

I just want the top line to be in Bold and to centre the other lines.

i know that it is possible to make lines Bold in a message box, does anyone know how?

many thanks for any help

It's OK. I found the answer now.

Apparently you can only do it in Access/Excel 97. fantastic.