VBA Training

[Dazzawm]

I am going to do a course on VBA training. I am bit of a novice but I do know basic functions and how to record macros. Is there any free online courses, videos etc that you can recommend so that I can get a bit of a head start for the course. I have listed below what will be in the course. Thanks.

Content
​

Introduction
What is a Macro
Recording & Running a Macro
Relative References

Assigning Macros to Buttons and Objects
Assigning a Macro to a Button or a Drawn Object on a Sheet
Assigning a Macro to a Button on a Toolbar

Editing Macros
Visual Basic Editor
Project Explorer
Procedures; Inserting Comments
Printing a Visual Basic Module

Improving macro performance
Aesthetic improvements
Increasing speed

Creating VBA Projects
Structuring an application
Identifying Modules and procedures
Writing and testing tight and concise VBA code
Adopting good programming practices

Developing the course project
Collecting user input
Verifying success of each procedure
Understanding an application’s requirements

The Range Object
Cells & Range Method; Flexible Ranges
Virtual Worksheets; Range Contents

Workbooks and Sheets
Activating a Workbook & Worksheet
This Workbook

Objects, Properties & Methods
Controlling Objects with their Properties
Performing Actions with Methods
Performing Multiple Actions on an Object

Variables
Variables and associated Data Types
Object Variables

Control Structures
Conditional & Looping Control Structures
Non-Structured Statements
Sub Procedures

Using Controls
Adding Worksheet Controls
Worksheet Control Properties

Designing VBA Forms
Using Drop Down Lists

Debugging & Error trapping
Errors, Break Mode; Instant Watch
Stepping & Error Handling

Function Procedures
User Defined Functions

Course summary
Save VBA project to disc
​

 

[Dazzawm]

^

 

[xenou]

Just relax and enjoy the course Still can't wait? I've always thought these tutorials looked decent:

http://www.anthony-vba.kefra.com/index_011.htm

There's a surprising amount of stuff on youtube these days if you just type in VBA or Visual Basic.

I'm a book-ish type so I'd recommend Excel VBA Programming For Dummies by (the not a dummy) John Walkenbach.