VBA Online
Learn to automate repetitive Excel tasks with macros and Visual Basic Applications. Learn to debug programs and extend macros with variables and For Next loops. Learn to use Excel functions programatically and create User Defined Functions (UDFs). Learn to work with object variables and array variables within For Each and Do While loops. Courses are hands-on and include practice exercises.
- The only instructor led online webinar that teaches VBA Programming for 32 hours!
- The only class with homework to practice
- Become a subject matter expert
- Become indispensable at work
- Includes recorded videos
- Includes a 560+ page PDF
Schedule
Sale: $495 $349
- January 6th, 7th, 8th, 13th, 14th, 15th, 20th, 21st, 22nd, 27th, 28th, 29th, February 3rd, 4th, 5th, 10th 4pm EST
- January 6th, 7th, 8th, 13th, 14th, 15th, 20th, 21st, 22nd, 27th, 28th, 29th, February 3rd, 4th, 5th, 10th 10pm EST
Frequently Asked Questions
- Save time + money commuting
- Learn more and pay less, a better value
- More time for practice (aka homework)
- Weekly Q&A session.
- Live instruction includes recorded videos
- The 32 hour class covers VBA Programming from A-Z so you can become a master.
- What types of programs will I learn to create?
The class teaches several algorithms, approaches to solving problems with programming. Before you can use VBA to reconcile two workbooks you need to learn a few programming fundamentals. Fundamental algorithms include:
How to find the last row/column of data in a range.
How to locate key columns and use named ranges.
How to loop through a scenario.
How to read and write from/to cells (internal) and databases (external).
How to loop from row to row, sheet to sheet and workbook to workbook and process data with functions.
How to reconcile data between two workbooks.
How to communicate while a program is running and accept inputs with message boxes, input boxes and user forms.
How to debug programs and handle errors gracefully.
How to manage PivotTable reports.
How to communicate with web browsers, Word, PowerPoint, and Access. - See the outline of topics below – or download a PDF.
In order to succeed in this class you will need:
- A computer with Excel installed;
- Knowledge of topics from the Excel Online course;
- VBA requires you to type – alot. You should be able to type at least 20 words per minute – with reasonable accuracy – or learning to program will be difficult.
- Optionally: A second monitor – one to use during class, another to watch the instructors screen (could be a phone or tablet)
Glenn Harris has taught Excel for 26 years and is a Microsoft Certified Trainer and Office Master Instructor. Prior to learning Excel, Glenn mastered Lotus 1-2-3 programming.
Glenn programs in many languages that include: COBOL, Fortran, Pascal, VB, VBA, PhP
Glenn has written over 600,000 lines of VBA code over the course of 20 years!
Reviews
Lesson 1
- Macros – Recording
- Macros – Triggering
- Macros – Editing
- Save As Macro Enabled
- Macro Security
Lesson 2
- Edit Macros – VB Editor
- Password Protect VBA Code
- Edit Macros – Debug Step
- Write VBA Programs to Call Macros
- Variables and Constants
- Variable Concatenation and Substitution
Lesson 3
- Writing VBA Programs Without Macros
- Pseudocode
- Whitespace
- Variables – Detailed
- Navigate Cells
- Range Object
- Name Ranges
- Cells Object
- Column and Row Objects
- Selection Object
- Offset Property
- End Property
- Find the Last Row of Data
- Cell Visibility Considerations
- Navigate Sheets
- Add and Name Sheets
- Named Arguments
- Count Sheets
- Sheet Visibility
- Navigate Workbooks
- Passwords on Workbooks
Lesson 4
- Copy, Paste, PasteSpecial
- Find Command
- Read From Cells
- Write To Cells
- For Loops
Lesson 5
- Error Handling
- Coding Exercises with Day 4-6 Keywords
- Functions – Intrinsic
- Formulas and Functions with VBA
- Function Approach To Find Last Row
Lesson 7
- User Defined Functions
- Dialogs
- Variable Data Type
- Conversion Functions
- Workbook Events
- This Workbook Object
- Worksheet Events
- Intersections
- Select Case Decision Control Structures
Lesson 8
- Pass Variables Between Subs
- Local Versus Global Variable Declaration
- Data Validation and Data Filters
- Coding Exercises with Day 8-9 Keywords
Lesson 9
- Coding User Forms Part 1
Lesson 10
- Coding User Forms Part 2
Lesson 11
- Indefi nite Loops – While/
Wend, Do/While, Do Until - Object Variables
- Automate Charts
Lesson 13
- Pivot Tables
Lesson 14
- Communicate With Other Office Programs: Word, PowerPoint
Lesson 15
- Communicate with
Databases, Access and SQL - Set VBA Programs to Run
At Specific Days and Times
Lesson 16
- Communicate with
Windows Control Panel
Lesson 17
- Coding To Modify Ribbon
- Save as an Add In
Lesson 18
- Read and Write To External Text Files
- Loop Through A Folder
Import and Parse PDFs
Lesson 19
- Class Modules
- Properties