Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Message Box

Message Box

ResolvedVersion 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:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Message Box

Message Box

RE: Message Box

Excel articles

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010