Click or tap a Section below to expand.
1.1 Developer
1.2 VBA Editor
1.3 Macros
1.4 Dot Notation
1.5 Toolbar
1.6 Buttons
1.7 Offset
1.8 Resize
2.1 Variables
2.2 Variable Practice
2.3 Option Explicit
2.4 Add/Subtract
2.5 Multiply/Divide
2.6 More Types
3.1 If Statements
3.2 Else ... Else If
3.3 Conditions
3.4 Logic Operators
3.5 VBA Practice 1
3.6 VBA Practice 2
3.7 Select Case
3.8 VBA Practice 3
3.9 With ... End With
4.1 VBA Strings
4.2 Change Case
4.3 Trim, Len, Space
4.4 Replace
4.5 In the String?
4.6 Left and Right
4.7 VBA Mid
4.8 String Exercise
5.1 VBA For Loops
5.2 VBA For Each
5.3 Cells Property
5.4 Do Loops
6.1 An Introduction to Arrays
6.2 Arrays, Loops
6.3 Multi Arrays
6.4 Arrays and Split
7.1 Subroutines
7.2 Pass Value to Sub
7.3 The Message Box
7.4 Functions
7.5 Worksheet Function
7.6 The Set Keyword
8.1 Open Text File
8.2 Write to file
9.1 User Forms
9.2 Form Buttons
9.3 Launch a Form
9.4 Add Tab to Ribbon
9.5 Customize Excel Ribbon
10.1 Excel Picture Viewer
10.2 Design a Form
10.3 Add Buttons
10.4 Add New Tab
10.5 Form Initialize
10.6 Textbox Data
10.7 VBA Option Button
10.8 VBA ImageBox Code
10.9 Next/Previous Buttons
10.10 Add New Photo
10.11 Save New Image
10.12 Copy Image
11.1 Chart Sheets
11.2 Embedded Charts
11.3 Charts Forms, P1
11.4 Charts Forms, P2
11.5 Chart Constants
12.1 TreeViews
12.2 Parent/Child Nodes
12.3 Initialize Nodes
12.4 Node Click Event