If you work with macros quite a lot, you can use message boxes to denote the ending of the execution of the macro.

You can create VBA macros which incorporate personalized messages or accept user messages by using the 'MsgBox' command. To begin with, you need to enable the 'Developer' tab as it is disabled by default. To enable, carry out the following steps:

Start Excel 2007. Click the 'Office button'.

Select the 'Excel Options' button appearing at the foot of the drop-down list.

Click the 'Popular' tab from the left-side panel of the 'Excel Options' dialog box.

Check the 'Show Developer tab in the Ribbon' option. Click 'OK'.

To use message boxes in your macros, follow the steps below.

Go to the 'Developer' tab.

Click the 'Visual Basic' button appearing under the 'Code' group of the tab. The 'Microsoft Visual Basic Book" editor opens.

Create the macro as per your requirement and add the command mentioned as under. You can also add symbols to make it more relevant.

'MsgBox 'Macro Completed', 48'

Save the macro and use it as per

Two tabular structures explaining the number of buttons, button type and icons are also listed for your convenience.