VBA with Microsoft Excel Course

Visual Basic for Applications (VBA) is an extensible programming language.

VBA with Microsoft Excel Online Training

Visual Basic for Applications (VBA) is an extensible programming language that is made up of a core set of commands and extended on a per application basis to be able to work directly with objects in that application. This means that VBA for Excel knows about things like workbooks,worksheets, cells and charts and more; while VBA for Access knows about tables, queries, reports and data entry forms, among other things.

What you will learn

Other tasks, like changing the format of a range of cells, are repeated often but can be done quickly by using tools in Excel. However, you often have one or two tasks that you perform frequently and that require a lot of steps to accomplish.

  • Introduction to VBA
  • VBA-Excel Spread sheet Objects

VBA with Microsoft Excel Online Training Course Content

 

  • Introduction to VBA
  • What is VBA, Advantages of Automation
  • VBA user interface
  • Project Explorer
  • Properties Window
  • Tool Bars , Debugging
  • Recording Macros, Editing Macros
  • Introduction to Programming
  • Operators and Operands
  • variables and Data types
  • Introduction to Procedures , Functions and Sub Procedures
  • Introduction to Objects
  • VBA-Excel Spread sheet Objects
  • Working with rows, columns and cells (Formatting, Alignment, Styles)
  • Workbooks , worksheets (Creating, Modifying, Deleting)
  • Introduction to Functions
  • Creating new functions (procedures)
  • Creating Add-in's
  • Review of Built-in Functions
  • Introduction to
  • Conditions ( if , OR , AND) – nested if's , multiple if's
  • Loops – (For, while , do-while) , Options (Select)
  • Strings , Dates and time Functions
  • String Functions – Left, Right, Mid, Instr, Len, Char and Concatenate
  • Date Functions
  • Creating User defined Functions
  • Creating Simple User Defined Functions
  • Exporting Functions as Add-ins
  • Creating Multiple procedures (calling from one function to another function)

 

  • Working with Sub Procedures
  • Creating Sub Procedures , Events
  • Working with Multiple Sub Procedures
  • Working with pivot tables using with Macros
  • Working with Chartsusing with Macros
  • Security
  • Securing the workbooks and worksheets with VBA
  • Securing Source code (VBA Project)
  • Export and Import
  • Introduction to Forms and Controls
  • Creating Forms , Adding Form controls
  • Messages and alerts , inputs using dialog boxes
  • Interactive Forms - Advance
  • Introduction to Forms
  • Introduction to Controls
  • Creating Forms
  • Creating Multiple forms
  • Page controls , Events
  • Uploading / Importing Data from various sources using Forms
  • Data entry with Forms
  • Introduction to VBA with other MS-Applications
  • Creating Macros in MS-Word
  • Creating Macros in MS-Access
  • Projects (practice in class):
  • Creating Macro to format excel worksheets.
  • Extracting data from one workbook to another worksheet, workbook.
  • Writing own sum, count, max, average functions.
  • Interactive calculator with form (Simple interest).
  • Updating data to excel using forms.
  • Refreshing Pivot tables data with buttons.
  • Consolidation of multiple excels workbooks.
  • Creating Excel Templates using macros.
  • Multi-Page Control, Creating a wizard using the Multi-Page Control.
  • Creating workbook with domain authentications.
Back to top