on-demand course

Excel VBA Programming - The Complete Guide

with Boris Paskhaver

August 2019

Intermediate

17h 19m

English

Packt Publishing

Closed Captioning available in English

Watch now

Unlock full access

Includes

Includes Quizzes

Earns Badge

Course outline

(Free Preview) Introduction
13m 0s
(Free Preview) Enable the Developer Tab
7m 7s
Excel File Types
4m 0s
Macro Security
8m 44s
The Macro Recorder
15m 13s
Absolute vs. Relative References I
8m 13s
Absolute vs. Relative References II
8m 15s
The Visual Basic Editor
9m 2s
(Free Preview) Object-Oriented Programming in Real Life
11m 29s
Collection Objects in Real Life
5m 50s
Objects as Properties
9m 9s
The Excel Object Model
13m 34s
Access Object from Collection by Name
3m 57s
Default Properties
3m 39s
The Name Property on Workbook and Worksheet Objects
4m 4s
Visual Basic Editor Options
13m 40s
(Free Preview) Create and Delete a Procedure
8m 52s
The Immediate Window and Debug.Print Method
8m 45s
The MsgBox Method
13m 35s
Comments
5m 19s
Methods without Arguments
3m 28s
Methods with Arguments
8m 30s
Methods with Multiple Arguments
6m 43s
The Object Browser
5m 29s
Ways to Invoke A Procedure
8m 17s
The TypeName Method
5m 54s
Syntax Tips
7m 38s
Variable Declarations and Assignments
10m 1s
Multiple Variable Declarations
4m 15s
The Option Explicit Setting
5m 52s
The Byte, Integer and Long Data Types
7m 54s
Mathematical Operations
6m 7s
The Single and Double Data Types
5m 59s
The String Data Type
4m 58s
The Boolean Data Type
4m 25s
The Date Data Type
6m 22s
The Variant Data Type
5m 42s
The Object Data Type
8m 5s
Default Values for Declared Variables
2m 53s
Variable Scope
9m 31s
Call A Procedure from Another one
3m 55s
Procedures with Arguments
7m 15s
Procedure Scope (Public vs. Private)
6m 54s
The Exit Sub Keywords
1m 50s
Constants
6m 49s
(Free Preview) Predefined Constants
11m 0s
The Application Object
4m 14s
The Application.DisplayAlerts Property
6m 26s
The Workbooks.Count and Worksheets.Count Properties
2m 7s
The Workbooks.Open Method and Workbook.Path Property
6m 59s
The Workbooks.Close Method
1m 47s
The Workbooks.Add Method
5m 56s
The Workbook.SaveAs and Workbook.Save Methods
9m 32s
The Workbook.Activate Method
6m 58s
The Workbook.Close Method
4m 13s
The Worksheets.Add Method
5m 27s
The Worksheet.Visible Property
5m 12s
The Worksheet.Copy Method
3m 35s
The Worksheet.Delete Method
2m 24s
The Worksheet.Move Method
2m 59s
(Free Preview) The Range.Select Method
8m 43s
The Value vs. Text Properties
3m 50s
R1C1 Notation, Part I
9m 53s
R1C1 Notation, Part II
7m 55s
The Formula and FormulaR1C1 Properties
6m 47s
The Range.Offset Property
5m 5s
The Range.Resize Property
3m 53s
The Cells Property
4m 43s
The Range.CurrentRegion Property
5m 0s
The Range.End Property
8m 24s
The Range.Count and Range.CountLarge Properties
3m 21s
The Range.Row and Range.Column Properties
2m 26s
The Range.Rows and Range.Columns Properties
7m 0s
The Range.EntireRow and Range.EntireColumn Properties
2m 55s
Get Last Row of Data in Worksheet
6m 24s
The Range.FillDown Method
5m 1s
The Range.Replace Method
4m 42s
The Range.TextToColumns Method
9m 28s
The Range.Worksheet Property
2m 9s
The Range.Sort Method
12m 32s
The Range.Font Property
9m 7s
The Range.Interior Property
6m 41s
The Range.ColumnWidth and Range.RowHeight Properties
6m 28s
The Range.AutoFit Method
2m 58s
The Range.Clear, Range.ClearContents and Range.ClearFormats Methods
4m 3s
The Range.Delete Method
5m 54s
The Range.Copy and Range.Cut Methods
4m 0s
The Paste and PasteSpecial Methods on the Worksheet Object
4m 56s
The Parent Property on All Objects
4m 23s
Boolean Expressions
6m 27s
The If Then Statement
4m 5s
The ElseIf and Else Statements
10m 42s
Select Case
10m 42s
The AND & OR Logical Operators
6m 35s
The NOT Operator
7m 27s

Content preview from Excel VBA Programming - The Complete Guide

The Range.Sort Method

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Excel VBA Programming For Dummies, 6th Edition

Dick Kusleika

Microsoft Excel 2021/365 - Beginner to Advanced

Simon Sez IT

The Complete Excel Guide: Beginners to Advanced

Simon Sez IT

The Ultimate Excel VBA Course

Najib Abdallah

Publisher Resources

ISBN: 9781839214240Supplemental Content

Excel VBA Programming - The Complete Guide

with Boris Paskhaver

Chapter 1 : Getting Started

Chapter 2 : The Fundamentals of the Excel Object Model

Chapter 3 : The Visual Basic Editor

Chapter 4 : Objects and Methods

Chapter 5 : Variables and Data Types

Chapter 6 : Procedures

Chapter 7 : Object Deep Dive

Chapter 8 : Range References

Chapter 9 : Range Actions

Chapter 10 : Conditionals

Chapter 11 : Iteration

Chapter 12 : Miscellaneous Features

Chapter 13 : Arrays

Chapter 14 : Functions

Chapter 15 : Debugging

Chapter 16 : Events

Chapter 17 : User Forms

Content preview from Excel VBA Programming - The Complete Guide

The Range.Sort Method

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

Excel VBA Programming For Dummies, 6th Edition

Microsoft Excel 2021/365 - Beginner to Advanced

The Complete Excel Guide: Beginners to Advanced

The Ultimate Excel VBA Course

Publisher Resources

Chapter 1 : Getting Started

Chapter 2 : The Fundamentals of the Excel Object Model

Chapter 3 : The Visual Basic Editor

Chapter 4 : Objects and Methods

Chapter 5 : Variables and Data Types

Chapter 6 : Procedures

Chapter 7 : Object Deep Dive

Chapter 8 : Range References

Chapter 9 : Range Actions

Chapter 10 : Conditionals

Chapter 11 : Iteration

Chapter 12 : Miscellaneous Features

Chapter 13 : Arrays

Chapter 14 : Functions

Chapter 15 : Debugging

Chapter 16 : Events

Chapter 17 : User Forms

Content preview from Excel VBA Programming - The Complete Guide

The Range.Sort Method

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Excel VBA Programming For Dummies, 6th Edition

Microsoft Excel 2021/365 - Beginner to Advanced

The Complete Excel Guide: Beginners to Advanced

The Ultimate Excel VBA Course

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.