Chapter 1: The Range Object
1
Get the Developer Tab and Intro to Developer Tab
1:29
2
Getting Started With Range Object
1:19
3
Quick Tip - Project Explorer and Properties Window!
1:12
4
Creating Your First Macro From Scratch
2:29
5
Adding a Secondary Command
0:51
6
Debugging in Excel VBA
1:22
7
Saving a Macro-Enabled Workbook (.xlsm)
1:11
8
Before You Begin The Exercises
3:06
10
Several Ways to Trigger Your Macro
1:22
11
Affecting Multiple Cells with One Range Command - 2 Methods
1:35
12
Adding Strings of Text to a Cell
1:40
13
Using a Named Range with the Range Object
1:37
Chapter 2: Range Properties
16
ROW and COLUMN Properties
1:07
22
NUMBERFORMAT Property
2:27
23
FONT, BOLD, UNDERLINE or ITALIC Properties
2:43
Chapter 3: The Cells Object
26
Using Column Letters Instead of Numbers
0:55
27
Using Cells Positionally Within a Range
2:10
28
Affecting ALL Cells in a Worksheet
2:05
30
Using Range Object with Cells Object
3:01
Chapter 4: Variables
31
Intro to Variables
2:24
32
Declaring Variables - Variable Types
2:37
33
Declaring Variables - Types Demo
4:24
34
Concatenation - Joining Two Or More Strings!
2:26
35
BONUS - Date Math Fun!
3:41
37
Calling a Procedure from Another
1:57
38
Public and Private Variables
3:06
40
BONUS - Passing Variables to Another Procedure - ByVal and ByRef
7:05
Chapter 5: Toolbars and Menus
41
File Menu Walkthrough
1:52
42
Edit Menu Walkthrough
5:08
43
View Menu Walkthrough
2:12
44
View Menu - Watch Window, Local Window and Immediate WIndow
7:43
45
Watch Window Wonders!
3:25
46
Insert and Format Menus
0:40
48
Run and Tools Menus
2:13
Chapter 6: Important Tools and Excel Logic
49
Determining the Last Row in your Data Set
3:17
50
Determining the Last Column in your Data Set
2:22
51
Determining the Next Row in your Data Set
1:06
52
Recording a Macro
3:39
53
BONUS - Dynamic Sorting
5:55
54
Absolute vs. Relative References
4:07
55
Using With and End WIth
3:32
56
Comparison Operators in Excel VBA
1:01
57
If Then Statement
2:25
58
Using Is Not Equal To ()
0:41
59
Logical Operator, NOT
0:56
61
If, Then, Else Statement
1:22
62
If, Then, ElseIF Statement
2:02
63
Comparative Operators with Text and Numbers
2:35
64
Using If Then Statements in a One-Liner of Code
1:42
65
Using GOTO and Labels
1:52
66
Select Case as Alternative to IF THEN Statements
2:21
67
Message Box with Yes and No Buttons
6:26
69
Relative Positioning Using Offset
4:13
70
BONUS - User Defined Functions 101
4:49
71
BONUS - UDF Lesson 2
4:08
Chapter 7: Loops and Report Writing Basics
72
Intro to Loops; the For Next Loop
3:07
73
Fun with out For Next Loop
3:46
74
Beginning out First Report Using Loops
5:46
75
Using an InputBox
2:53
76
Adding InputBox to Our First Report to Make It Dynamic
3:12
77
Add a Button to Open Our Report
2:23
78
Add a Cool Button or Image to Open Report
2:19
79
Our First Printable Report, Part 1
5:00
80
Printable Report, Part 2
6:41
81
Printable Report, Part 3
3:19
82
Printable Report, Part 4
3:34
84
Using PrintPreview Automatically
0:50
85
Using PrintOut to Send Directly to Default Printer
1:59
86
Handling Debug Error When Cancelling InputBox
2:18
87
For Loop Going Backwards Using STEP
2:49
88
The FOR EACH Loop
5:17
89
FOR EACH Loop - Practice Examples
3:30
91
Intro to DO LOOPS
3:26
96
EXIT DO - Multiple Exits Using Your Own Criteria Along the Way!
1:48
97
BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each
12:09
Chapter 8: Events, Worksheet Events Made Easy
98
Intro to Worksheet Events and Selection Change
4:03
99
Worksheet Activate Event
1:13
100
Worksheet Deactivate Event
2:28
101
BeforeDelete Event - For Worksheet Deletion
1:05
102
BeforeDoubleClick Event - Trigger a Macro When Double Clicking
2:59
103
BeforeRightClick Event - Trigger a Macro When Right-Clicking
1:42
Chapter 8: Events, Worksheet Events Made Easy
106
How to Disable Events on the Workbook
1:32
107
Intro to Change Event
1:14
108
Change Event with EnableEvents Toggle - Avoid Endless Loop!
4:51
109
Change Event Triggered With Custom Range Using Intersect
3:19
110
FollowHyperlinks Event
2:41
111
Final Thoughts on Worksheet Events and Review Other Events
2:25
Chapter 9: Workbook Events
114
Workbook Activate
1:53
124
Delete, DoubleClick, RightClick, Calculate, Change
4:51
126
Follow Hyperlink
0:44
127
SheetSelectionChange
0:42
129
WindowDeactivate
0:25
Chapter 10: Activex Controls of Worksheets
131
Activex Controls vs. Forms Controls
3:36
132
Button Click - Wage Calculator
4:10
134
BONUS: Capturing Shift, Alt, Ctrl or Some Combination Using the Shift Variable
3:19
137
MouseMove Event with Application Statusbar
3:44
138
MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl
6:27
139
GotFocus and LostFocus Events
1:09
140
Use a Checkbox for its VALUE
2:41
141
Checkbox Event Without a Button
1:58
142
LinkedCell Property With a Checkbox
1:59
143
Option Buttons Intro - What is an Option Button and Grouping
3:08
144
Grouping, Alignment and Aesthetics for Control
2:45
145
Homemade Quiz Using Option Buttons and a Command Button
4:37
146
Compliance Checker for Your Forms or Quizzes, Part 1
3:36
147
Compliance Check, Part 2
9:49
148
SpinButton With Cell A1
4:21
149
SpinButtons With Textboxes and Numbers
6:04
150
SpinButton BONUS - Move Textbox Position with SpinButton
3:55
151
SpinButton With Dates in a Textbox
3:31
152
Activex "Label" Control - Basics
3:50
153
ComboBox - Fill With ListFillRange
3:33
154
Creating a Dynamic Range
4:47
155
ComboBox - How To Use Multiple Columns
3:09
156
Using ADDITEM to Get Specific Items in Your ComboBox List
9:25
157
Noteworthy Properties of a ComboBox
5:37
158
Multiple Columns in ComboBox With ADDITEM and List, ListCount, etc.
7:16
159
ListBox Basics Using Dynamic Range
7:47
160
ListBox Click Event and Dynamic Options
3:26
161
BONUS - Manipulating and Using Multiselect Items in a Listbox
6:04
162
ListBox - Referencing Column 0 and 1 in a Cell Dynamically
3:32
163
Dynamic ListBoxes Using ADDITEM and More
9:36
164
Make and Utilize INVISIBLE Columns - Special Trick!
3:35
165
Using Scroll Bar on a Worksheet
3:29
166
Pictures on a Worksheet, Plus Using FollowHyperlink Method
5:52
168
A Brief Note on Alternate, 3rd Party Controls
1:33
Chapter 11: Userforms - The Best Thing Ever!
169
Userform - Hide, Show and Unload
3:19
170
Simple Database and Creating a Data Entry Form
3:55
171
Fill Status ComboBox With Rowsource When Userform Starts - 2 Methods
4:03
172
New Employee Data Entry Form
9:04
173
Format Textbox Numbers as Numerals, Clearing Out Form Upon Submission
3:13
174
Set the Tab Order for Userform Controls
2:10
175
Set Default Values to Make Data Entry Easier
2:18
176
Avoid Duplicate Employee ID and Other Fun Automation Tricks
5:37
177
Edit Mode for Employee Database, Part 1
11:26
178
Edit Mode for Employee Database, Part 2
7:49
179
Edit Mode, Part 3 - Adding Automation and Save Button
15:56
180
BONUS - Refreshing the Rowsource After Updating Data
3:55
181
BONUS - Combobox by Last Name Instead of EmpID
9:41
182
BONUS - Search Name and ID
15:49
183
Userform Report with Filters, Part 1
11:09
184
Userform Report with Filters, Part 2
6:03
185
Applying the Dynamic Filters to Reports
3:10
186
Clear Out Last Report
3:06
187
Report Generation and Aesthetics, Headers, Footers, Footers, Repeat Rows, etc.
6:05
188
Advanced Exercise - Review of Objectives
8:04
189
Advanced Exercise 01 - Solution
7:57
190
Advanced Exercise 02 - Solution
4:10
191
Advanced Exercise 03 and 04 - Solutions
7:44
192
Advanced Exercise BONUS A and B - Solutions
3:41
193
Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions
3:21
Chapter 12: BONUS VBA Functions
194
InStr Function - Search for Text Within Other Text
7:18
195
The EVALUATE Function - Mac-Daddy of all functions
5:59
196
Sum Function in Excel VBA - EASY!
3:14
197
Count Function in VBA
2:13