Trusted Training Partners

Quick Look Course Summary:Writing Excel Macros with VBA Course
  • Next Public Course Date:

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 12,711.88 EX VAT 3 Person R 10,220.05 EX VAT 10 Person R 7,415.44 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Writing Excel Macros with VBA

    Course Introduction

    An Advanced course in Excel, not to be missed by participants who need to understand Excel Macros, VBA and programming. This is an excellent starter course in Visual Basic and programming for participants who work in Information Technology and want to learn programming. This is also for the new businessman who is setting up a domain or website.  

    Course Outline

    1. An Introduction to Excel Macros with VBA

    • Selecting Special cells
    • Setting Point Labels in Chart Data
    • Topics in Learning Excel Programming

    2. A brief Introduction

    • What is a programming language?
    • Programming Style.

    3. Visual Basic Editor Part 1

    • Arranging the Windows
    • The Code Window
    • The Immediate Windows
    • The Project Window
    • The Properties Window

    4. Visual Basic Editor Part 2

    • Creating Procedures
    • Debugging
    • Errors
    • Familiarising the IDE
    • Help
    • Macros
    • Estimated Running Time, Design Time and Break Mode

    5. Constants, Data Types and Variables

    • Add Data Types
    • Constants
    • Inserting Comments
    • Line continuation
    • Variables
    • VBA Operators

    6. Subroutines and Functions

    • Functions and Subroutines
    • Parameters and Arguments
    • Exiting a Procedure
    • Public and Private Procedures
    • Project References

    7. Built-in Functions and Statements

    • Introduction to programming language
    • Programming Style

    8. Control Statements

    • If…Then Statements.
    • Loop: For, For each and Do.
    • Select Case Statement
    • Conclusion of VBA

    9. Object Models

    • Objects, Properties and Methods
    • Collection Objects and Model Hierarchies
    • Object Model Syntax and Variables

    10. Excel Applications

    • Accessing an Application’s features
    • Storing Applications and Add-Ins (With example)

    11. Excel Events

    • Enable Events Property
    • Events and the Objects Model
    • Accessing an Event Procedure
    • Worksheet and Workbook Events
    • Chart Events
    • Application Events
    • Query Table Refresh Events

    12. Custom Menus and Toolbars

    • Introduction
    • Commands Bar
    • Command-bar Controls
    • Creating a New Menu Bar or Toolbar
    • Built-In Command-Bar-Control ID’s
    • Examples
    • Augmenting the SRXUtils Application

    13. Built-In Dialog Boxes

    • The Show Method

    14. Custom Dialog Boxes

    • Introduction to User Form Object
    • Creating a User Form Object.
    • ActiveX Controls
    • Adding User Form ODE3
    • Excel’s Standard Controls
    • ActiveX Controls on Worksheets

    15. The Excel Object Model

    • A brief perspective
    • Excel Enumerations
    • The VBA Object Browser

    16. The Application Object

    • Properties and Methods
    • Descendants of the Application Object

    17. The Workbook Object

    • The Workbooks Collection
    • The Workbook Object
    • Descendants of the Workbook Object
    • Sorting Sheets in a Workbook

    18. The Worksheet Object

    • Properties and Methods
    • Descendants of the Worksheet Object
    • Worksheet Protection
    • Printing sheets

    19. The Range Object

    • The Range Object as a Collection
    • Defining a Range Object
    • Additional Applications of the Range Object
    • Descendants of the Range Object
    • Calculating the Used Range
    • Selecting Special Cells

    20. Pivot Tables

    • Introduction to Pivot Tables
    • The Pivot Table Wizard
    • The Pivot Table Wizard Method
    • The Pivot Table Object
    • Properties and Methods of the Pivot Table Object
    • Descendants of the Pivot Table Object
    • The Pivot Field Object
    • The Pivot Cache Object
    • The Pivot Item Object
    • The Pivot Cell and Pivot Item List Objects
    • Calculated Items and Calculated Fields
    • Printing Pivot Tables

    21. The Chart Object

    • Creating a Chart
    • Chart Types
    • Scrolling through Chart Types
    • Dependants of the Chart Object
    • Chart Object Objects
    • The Axis Object
    • The Axes Collection
    • The Chart Area Object
    • The Chart Group Object
    • The Chart Title Object
    • The Data Table Object
    • The Floor Object
    • The Legend Object
    • The Page Setup Object
    • The Plot Area Object
    • The Series Object
    • Properties and Methods of the Chart
    • Printing Embedded Charts
    • Setting Data Series Labels

    22. Smart Tags

    • Introduction to Smart Tags
    • Smart Tag Recogniser Object
    • Smart Tag Object
    • Smart Tag Action Object
    • Smart Tag Options Object

     

    Benefits to attending: Writing Excel Macros with VBA Course

    • Find out the best ways to automate tasks in Excel
    • Understand the difference between macro recording and VBA and when to use which
    • Understand ways to do easy VBA programs
    • Significantly enhance effectiveness in the workplace relating to Excel

     

    Course Duration

    3 days  

    Who should attend

    This course is intended for anyone who already has a working knowledge of Excel and would like to broaden their knowledge regarding macros including:

    • Finance Personnel and supervisors
    • Information administrators, experts and managers
    • Project managers and Engineers Analysts
    • Anybody working extensively with Microsoft Excel
    • Delegates ought to have an affordable working understanding of MS Excel

    Contact Us Now!

     

    Please Phone Us Now To Speak to One of Our Friendly Consultants to Provide This Course around your schedule:

    Tel:011-882-8853

    Please Fill in the Form – We Will Get Back to You Within 15 minutes

    Please Email Us Now – We Will Get Back to You Within 15 minutes

    [email protected]

     

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Administrative Courses

      Leadership & Management Courses

      RPL & Learnerships Courses

      Software & IT Courses

      Top Rated

      ×