IIRF Online > Office Productivity > Microsoft > Excel VBA > Excel VBA Programming - The Complete Guide
Excel VBA Programming - The Complete Guide by Udemy
Automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA! Beginners welcome
Course Highlights
- Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
- Utilize the objects in the Excel Object Model to emulate user actions in Excel
- React dynamically to user events like entering a cell value or opening a workbook
- Feel comfortable with the fundamentals of computer programming
Skills you will learn!
Curriculum
12 Topics
Introduction
About Me
Download Course Materials
Enable the Developer Tab
Excel File Types
Macro Security
The Macro Recorder
Record Macro to Change Worksheet Orientation
Absolute vs. Relative References I
Absolute vs. Relative References II
The Visual Basic Editor
VBA Basics
9 Topics
Object-Oriented Programming in Real Life
Real Life Objects
Collection Objects in Real Life
Objects As Properties
The Excel Object Model
Access Object from Collection by Name
Default Properties
The Name Property on Workbook and Worksheet Objects
Object-Oriented Programming
8 Topics
Visual Basic Editor Options
Create and Delete a Procedure
Procedures
The Immediate Window and Debug.Print Method
The MsgBox Method
Comments
Practice with Procedures
The Visual Basic Editor
9 Topics
Methods without Arguments
Methods without Arguments
Methods with Arguments
Methods with Arguments
Methods with Multiple Arguments
The Object Browser
Ways to Invoke A Procedure
The TypeName Method
Objects and Methods
16 Topics
Syntax Tips
Variable Declarations and Assignments
Multiple Variable Declarations
The Option Explicit Setting
The Byte Integer and Long Data Types
Numeric Data Types
Mathematical Operations
The Single and Double Data Types
The String Data Type
String and Double Data Types
The Boolean Data Type
The Date Data Type
The Variant Data Type
The Object Data Type
Default Values for Declared Variables
Variable Declarations
8 Topics
Variable Scope
Call A Procedure from Another one
Procedures with Arguments
Procedure Scope (Public vs. Private)
The Exit Sub Keywords
Constants
Predefined Constants
Procedures
16 Topics
The Application Object
The Application.DisplayAlerts Property
The Workbooks.Count and Worksheets.Count Properties
The Workbooks.Open Method and Workbook.Path Property
The Workbooks.Close Method
The Workbooks.Add Method
The Workbook.SaveAs and Workbook.Save Methods
The Workbook.Activate Method
The Workbook.Close Method
The Application Workbooks and Workbook Objects
The Worksheets.Add Method
Add a New Worksheet to End of Current List of Worksheets
The Worksheet.Visible Property
The Worksheet.Copy Method
The Worksheet.Delete Method
The Worksheet.Move Method
16 Topics
The Range.Select Method
The Value vs. Text Properties
R1C1 Notation Part I
R1C1 Notation Part II
The Formula and FormulaR1C1 Properties
The Range.Offset Property
The Range.Resize Property
The Offset and Resize Properties
The Cells Property
The Range.CurrentRegion Property
The Range.End Property
The Range.Count and Range.CountLarge Properties
The Range.Row and Range.Column Properties
The Range.Rows and Range.Columns Properties
The Range.EntireRow and Range.EntireColumn Properties
Get Last Row of Data in Worksheet
14 Topics
The Range.FillDown Method
The Range.Replace Method
The Range.TextToColumns Method
The Range.Worksheet Property
The Range.Sort Method
The Range.Font Property
The Range.Interior Property
The Range.ColumnWidth and Range.RowHeight Properties
The Range.AutoFit Method
The Range.Clear Range.ClearContents and Range.ClearFormats Methods
The Range.Delete Method
The Range.Copy and Range.Cut Methods
The Paste and PasteSpecial Methods on the Worksheet Object
The Parent Property on All Objects
8 Topics
Boolean Expressions
Boolean Expressions
The If Then Statement
The ElseIf and Else Statements
Select Case
The AND & OR Logical Operators
Logical Operators
The NOT Operator
9 Topics
The For Next Loop
The Step Keyword
Deleting Rows
Fill Empty Rows
The For Each-Next Construct
Iterating over a Range of Cells with For Each
The With-End With Construct
Exit For and Review of Exit Sub
Iteration
8 Topics
The MsgBox Method In Depth Part I
The MsgBox Method In Depth Part II
MsgBox Options
StatusBar
The Application.ScreenUpdating Property
SpecialCells
The InputBox Function
The Application.InputBox Method
7 Topics
Intro to Arrays
Alternate Syntax for Fixed-Size Arrays
The Option Base 1 Syntax and Write Array Values to Cells
Initialize Arrays within a For Loop
The LBound and UBound Methods
Dynamic Arrays
The Range.RemoveDuplicates Method
8 Topics
VBA Functions Part I
VBA Functions Part II
The Split Function
The Is Family of Functions
Date and Time Functions
More Date and Time Functions
Excel Worksheet Functions
Custom Functions
6 Topics
Intro to Error Handling
The OnError and GoTo Keywords
The OnError Resume Next Keywords
Error and Err.Number
Stepping Through Code
Breakpoints
9 Topics
Introduction to Events
The Worksheet_SelectionChange Event
Review of Application.EnableEvents
The Worksheet_Change Event
The Worksheet_Activate Event
Highlight Row and Column Up to Cell Where Cursor Is Placed
Workbook Events and The Sh Argument
The Workbook_Open Event
Procedures with Boolean Arguments + The Workbook_BeforePrint Event
17 Topics
Create UserForm Toolbox Properties Controls
The Label and TextBox Controls
Naming Conventions
Naming Conventions
Design Aesthetics
The CommandButton Control
Add Event Procedure to Control
Unload and Hide a UserForm
Submit the UserForm
Activate a UserForm from Procedure
The initialize Event
The ListBox Control I - Wire up the Form
The ListBox Control II - React to User Selection
The ListBox Control III - Select Multiple Items
The ComboBox Control I
The ComboBox Control II
The CheckBox Control
1 Topic
Bonus!
Excel VBA Programming - The Complete Guide
Related Excel VBA Courses
Thank You!
Your review has been submitted successfully.