VBA application object in Excel

The "Application" is the root of any application where the program code is executing.

It has different meanings with different applications.

For example, with Excel VBA, The "Application" object refers to the entire Excel application.

This means, "Application " object is not bound only to the excel containg macro code.

Similarly, In MS Word, The same "Application" object refers to the entire MS Word.

The same is the case with MS Access VBA too.

There are numerous uses of this object and it offers a large number of functionalities some of which are discussed below:


The ScreenUpdating property of Application object is used to set the visual updation of the excel workbook to either TRUE or FALSE.

This property is useful while modifying a workbook with values and then saving it.

In this case, the excel screen will flicker while the program is executing and is not visually pleasing.

So, to avoid this, the ScreenUpdating property has to be set to FALSE.



This is also a useful member of the Application object.

With this, one can control the display of unwanted alert dialogs, which will hinder the speed of the program.

For example, while deleting a sheet, the excel usually displays a dialog box giving a warning and will proceed further only after an user action of a button click.

So, to avoid this during automation, the "DisplayAlerts" property is used, which if set TRUE, will not show the dialogbox and will automatically accepts the OK button click.

The same is the fact with Saving an excel.


If you see at the very first lines of this VBA Editor, you can see these two statements.

A screenshot of this is shown as below:

excel vba application object


You can find similar Excel Questions and Answer hereunder

1) What are the main cell objects in VBA

2) How to print a worksheet in Excel

3) How to do webscrapping in VBA. Here some basics

4) Vba length of an array in Excel

5) Highlight row of selected cell in Excel

6) Vlookup to return multiple values in same cell in Excel

7) How do you close, save, open files and do other operations in the workbook in VBA

8) Vba list all files in a folder in Excel

9) What is a methods. Methods are action that can be performed by an object

10) How to add email and emailing function in Excel VBA


Here the previous and next chapter