MsgBox

 

The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program. Place a command button on your worksheet and add the following code lines:

1. A simple message.

MsgBox “This is fun”

Result when you click the command button on the sheet:

Simple Message in Excel VBA

2. A little more advanced message. First, enter a number into cell A1.

MsgBox “Entered value is ” & Range(“A1”).Value

Result when you click the command button on the sheet:

Little More Advanced Message

Note: we used the & operator to concatenate (join) two strings. Although Range(“A1”).value is not a string, it works here.

3. To start a new line in a message, use vbNewLine.

MsgBox “Line 1” & vbNewLine & “Line 2”

Result when you click the command button on the sheet:

New Line