REAL-TIME

VBA Projects

Full Access with Source Code

  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

120+ PROFESSIONAL

Project Management Templates

120+ PM Templates Includes:

  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Effortlessly Manage Your Projects

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

Share Post

Excel VBA Application object is the one of the most frequently used object while automating any task with VBA. We refer different Excel applications and perform various operations on Excel Workbooks. We have different Properties, Methods to deal with Excel Application Object. Here you can find a brief explanation about each on most useful Properties and Methods while automating any task.

Our objective of building this Excel VBA Explorer is to provide suitable examples on most frequently used methods and properties of Application object. So that you can quickly find the solution, syntax whenever you required it.

Application Object

Application Object refers the entire Microsoft Excel Application. We can use Application Object to deal with Methods and Properties of the Entire Excel Application. Here are some Examples:

'To Disable the Display Alerts
Application.DisplayAlerts=False 

'To Disable the Application Events
Application.EnableEvents=False 

'To Minimize the Application Window
Application.WindowState = xlMaximized

Methods

Application methods helps us to perform different actions with Excel Workbooks. For example, we can Run a Application and Stop a Application ,etc.

Excel VBA Application Object Methods

  • Calculate: To Calculate all Open Workbook.
  • CalculateFull: To forces full caluculation in all the open Workbook.
  • FindFile: To display open dialog box to open a file.
  • Goto: To select any range.
  • Run: To run a procedure or function.
  • Wait: To stop running macro.

Properties

Properties of Application object will helps us to deal with various properties of Excel Applications. For example, we can change the Application Caption, sets the user name,sets the window state of the Application, etc.

Excel VBA Application Object Properties

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Last Updated: March 18, 2023

13 Comments

  1. CHANDRAKANT January 19, 2015 at 12:09 PM - Reply

    GOOD,,,,,,,…….

  2. Siddu April 8, 2015 at 10:26 AM - Reply 
    'Display or Hide Scroll Bars:
'TO DISPLAY
Application.DisplayScrollBars = True
'TO HIDE
Application.DisplayScrollBars = False


'Display or Hide Status Bar:
'TO DISPLAY
Application.DisplayStatusBar= True
'TO HIDE
Application.DisplayStatusBar= False

'To remove last copied data from clipart
Application.CutCopyMode = False

'TO set reference style in Excel:
'To set application reference style to R1C1  style
Application.ReferenceStyle = xlR1C1

'To set application reference style to Range("A1")style
Application.ReferenceStyle = xlA1

'To hide or unhide the workbook window
'To make excel window as invisible
Application.Visible = False

'To make excel window as visible
Application.Visible = True
  3. Venkat June 15, 2015 at 7:11 PM - Reply

    Dear Mr.P N Rao ! Your website Analysistab is a wonderful site where one can learn a lot about excel vba.Incase I

  4. Venkat June 15, 2015 at 7:11 PM - Reply

    Dear Mr.P N Rao ! Your website Analysistab is a wonderful site where one can learn a lot about excel vba.

  5. PNRao June 19, 2015 at 1:49 PM - Reply

    Thanks for the nice feedback Venkat! – PNRao!

  6. koolx June 21, 2015 at 2:04 PM - Reply

    I managed to hide the status bar in Excel 2013 using the code below. I can open a new workbook without the status bar. But when I open a saved workbook, it opens the saved workbook and a new workbook. How can I open just the saved workbook alone without opening a new workbook?

    Private Sub Workbook_Open()
Application.DisplayStatusBar = False
Workbooks.Add
ThisWorkbook.Close False
End Sub
  7. Deepa khilani July 1, 2015 at 11:00 PM - Reply

    Hi PNRao,

    I want to learn Excel VBA but I can not understand that how can I learn Excel VBA?

  8. PNRao July 2, 2015 at 12:16 AM - Reply

    Hi Deepa,
    The best way is to start with simple macros with Macro Recorder and Try to understand the Excel Object Model. You can follow our tutorials where we have provided numerous examples on Excel VBA.

    However, we are going to start our online classes in couple of weeks. You can joint if you are interested.

    Thanks-PNRao!

  9. Dela September 11, 2017 at 5:18 PM - Reply

    Hi PNRao,

    How can I pick the data in the cell to a vba variable then display in a text box arranged according to my preference.

  10. PNRao September 12, 2017 at 11:30 PM - Reply 
    Sub sbPickDataFromCellsofExcelApplication()

'Pick data from a Celll to Variable

myVar = Cells(1, 5) ' this is Row 1 and Column 5
'Or myVar=Range("E5")

'Assign the Variable value To a Text Box

TextBox1.Text = myVar

'OR You can directly assign the Cell or Range value
'TextBox1.Text = Cells(1, 5)

End Sub
  11. Krishna April 11, 2020 at 12:38 PM - Reply

    Hi i have 2000 files in which number of column is different few file having 90 column few is 80 columns and column sequence is also not same. i want to consolidate 15 columns from all the files only which is in every excel file and that columns name is also same in each file.
    can you please suggest solutions.

  12. javad July 10, 2024 at 11:37 AM - Reply

    Hi PNRao,
    Please let me know when your online classes will be held
    I want to participate in that class
    Thank you for your efforts
    Thank you so much for your great tutorials

    • PNRao July 29, 2024 at 12:40 PM - Reply

      Sure! We will let you know!
      Thanks!

Leave A Comment