Message Box

Resolved · Low Priority · Version 2007

Fri 30 Mar 2012, 14:00 Delegate Melanie said...

Melanie has attended:
Excel VBA Intro Intermediate course

Message Box

Trying to make the boxes, user forms, etc as 'friendly' as possible. I can change the properties of the user form no problem but dn't seem to be able to do the same with the Message Box. How can I change a Message Box colour/format/font - or do I have to go for a user form?

Mon 2 Apr 2012, 08:46 Trainer Anthony said...

RE: Message Box

Hi Melanie, thanks for your query. You will indeed have to go for a user form to have total control over formatting and appearance. The message box is "baked into" one of the dynamic link libraries of Visual Basic and apart from altering the number of command buttons on it there's not much else you can do with it.

Hope this helps,

Anthony

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

Message Box

Message Box

RE: Message Box

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel