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 10,632.50 EX VAT 3 Person R 7,874.42 EX VAT 10 Person R 5,341.19 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

Knowing your course will help us prepare for our consultation and phone call.

The more people you send on our courses, the cheaper the unit cost.

YesNo

Input this code: captcha

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

**Quote does not include Any Exam Fees (if applicable)

IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

 

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 *

Accredited Courses

Software & IT Courses

Top Rated