Course Description

This comprehensive course will benefit all those who wish to use Visual Basic for Applications (VBA) to create macros for automating repetitive tasks in Excel and understand how Python libraries been used to create VBA.

Prerequisite

In order to be successful with this course, delegates should already have a thorough working knowledge of Excel with understanding of level including how to create, edit, format, and print worksheets.

Course Outline

Review of Developing Macros

Create a Macro with the Macro Recorder

Edit a Macro

Debug a Macro

Different ways of running a Macro

The Visual Basic Environment

The Project Explorer

Properties

Object Viewer

Writing VBA Code

Properties

Methods

Objects

Subroutines

Immediate Window

Watch Window

Performing Calculations

Create User-defined Functions

Automate SUM Functions

Communicating with the User

Course Outline :: Excel VBA (Visual Basic for Applications) and Python::

Simple Message Boxes

Message boxes that return values

Buttons and icons

Input Boxes

Variables

Declaring Variables

Using Variables

Watching Variables

Control and Decision Structures

Conditional Statements

Decision Structures

Select Case

Looping

For next loops

Do While

Do Until

Error Trapping

Understanding error handling

Understanding VBA's error trapping options

Trapping errors with the on error statement

Understanding the error object

Writing an error handling routine

Working with inline error handling

Debugging the Code

Defining errors

Working with debugging tools

Determining breakpoints

How to step through code

Working with break mode during run mode

Identifying the value of expressions

Event Procedures

User Forms

Placing controls

Aligning Controls and Properties Menu

Course Outline :: Excel VBA (Visual Basic for Applications) and Python::

Python and VBA

Demonstration on

1. Python IDE installation
2. Python PIP installer
3. Library installation
4. Communication from Excel File and Python
5. Working with Python VBA invoker
6. Sample files and working Demonstration

Programme scope, delivery arrangements and suitability are confirmed during enquiry.