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

  • Length: 3 day(s)

  • Price: 1 Person R 10,632.50 EX VAT 3 Person R 7,212.50 EX VAT 10 Person R 5,072.94 EX VAT

  • Certification Type:Accredited

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

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.

Benefits to attending: Writing Excel Macros with VBA Course

Find out the best ways to automate tasks in Excel
Comprehend 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

Writing Excel Macros with VBA Course :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

Writing Excel Macros with VBA Course: Course Duration

3 day/s

Who should attend: Writing Excel Macros with VBA Course

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.  

Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Get Free & personalised
Training Advice

Enjoy incredible savings the more delegates
you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

Select Date *

Premises Provided by *

Laptop Provided by *

Region *

Administrative Courses

Human Resources Courses

Leadership & Management Courses

RPL & Learnerships Courses

Soft Skills Courses

Software & IT Courses

Specialist Courses

Top Rated