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 Training and help » Msgbox

Msgbox

ResolvedVersion 2003

Fri 3 Apr 2009, 17:03 Delegate Alison said...

Alison has attended:
Excel VBA Intro Intermediate course

Msgbox

what is the syntax for creating a message box in VBA?

Sun 5 Apr 2009, 22:18 Trainer Carlos said...

RE: msgbox

Hi Alison

The VBA syntax for creating a message box is

Msgbox(Prompt, [Buttons As vbMsgBoxStyle], [Title], [Help File], [Context])

Only the prompt is compulsory. When only the prompt is used the system creates a message box with an OK button.

Hope this helps

Carlos

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Msgbox

Msgbox

RE: msgbox

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel