Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel VBA Programming: Unleash Your Excel Expertise from Novice to Advanced
Course Introduction
Source Files
1. Course Overview (2:24)
2. How To Save Macros (1:34)
Send Messages with MsgBox
Source Files
1. Topics Overview (0:54)
2. Build A Simple Message (3:34)
3. Build An Advanced Message (5:10)
4. Empty A Sheet With The Msgbox Function (6:44)
5. Prompt User For Input (7:30)
Workbook and Worksheet Object
Source Files
1. Topics Overview (1:30)
2. Object Hierarchymp4 (5:10)
3. Change Multiple Worksheets (7:05)
4. Add And Count Worksheets (6:01)
5. Get Path Of A Workbook (5:14)
6. Open And Close Workbooks (8:41)
7. Loop Through Worksheets And Workbooks (8:20)
8. Build A Sales Calculator (11:54)
9. Change Charts (10:30)
Work with the Range Object
Source Files
1. Topics Overview (1:22)
2. Program A Range Of A Spreadsheet (6:55)
3. Use Cells Instead Of A Range (6:04)
4. Use A Range Variable (6:04)
5. Select A Range (4:52)
7. Access A Row (4:35)
8. Copy And Paste A Range (8:45)
9. Clear A Range (3:59)
10. Count A Range (4:21)
Work with Range Properties
Source Files
1. Topics Overview (1:03)
2. Find The Current Region Of A Cell (7:23)
3. Dynamic Range Program (7:11)
4. Resize A Range (2:30)
5. Select Entire Rows And Columns (6:33)
6. Offset Property (3:32)
7. End Property (5:06)
More Range Projects
Source Files
1. Topics Overview (1:21)
2. Union And Intersect Of Ranges (4:24)
3. Detect Content (5:38)
4. Build A Range Program (5:47)
5. Change Text Color (4:30)
6. Bold A Range (2:39)
7. Change Cell Color (5:04)
8. Work With Areas (4:55)
9. Find Differences In Ranges (8:17)
Variables
Source Files
1. Topics Overview (1:38)
2. Integer Data Type (2:58)
3. String Data Type (2:20)
4. Double Data Type (2:54)
5. Boolean Data Type (4:05)
6. Retain Variable Value (2:54)
Work with Conditionals
Source Files
1. Topics Overview (1:26)
2. If Then Statement (4:38)
3. Else Statement (4:55)
Work with AND, OR and NOT
Source Files
1. Topics Overview (1:21)
2. Greeting Program - Logical Operator And (4:00)
3. Logical Operator Or (5:37)
4. Logical Operator Not (3:15)
Build Conditionals Projects
Source Files
1. Topics Overview (1:58)
2. Select Case (5:42)
3. Build A Commission Calculator Project (6:11)
4. Find Remainder With Mod (3:11)
5. Check Number Program (6:38)
6. K Smallest Value Program (6:54)
7. Group By Font Style (6:45)
8. Remove Empty Cells (5:26)
Introduction to Loops
Source Files
1. Topics Overview (0:57)
2. Single Loop (5:59)
3. Double Loop (5:14)
4. Triple Loop (6:24)
5. Do While Loop (5:34)
6. Build A Commission Table (5:33)
Loop Projects
Source Files
1. Topics Overview (1:40)
2. Loop Through Defined Range (3:37)
3. Loop Through Entire Column (3:29)
4. Do Until Loop (3:22)
5. Use Step To Increment (4:23)
6. Build A Pattern Project (4:50)
7. How To Sort (5:32)
8. Sort By Related Data (8:15)
9. Delete Duplicate Values (6:10)
String Manipulation
Source Files
1. Topics Overview (1:28)
2. Join Strings (3:13)
3. Extract Substrings From Left Or Right (3:07)
4. Extract Substring At Middle (4:12)
5. Get Length Of A String (2:40)
6. Get Substring Position (3:16)
7. How To Split Strings (4:56)
8. Reverse Characters (4:10)
9. Change String Casing (3:28)
10. Count Words In A Range (8:17)
Build Custom Functions
Source Files
1. Topics Overview (1:19)
2. Make And Use Your Own Function (6:33)
3. Pass Arguments To A Function (7:43)
4. Custom Calculator Function (6:23)
Build Arrays
Source Files
1. Topics Overview (1:18)
2. One Dimensional Array (5:46)
3.Two Dimensional Array (6:26)
4. Change Array Size (4:54)
5. Build An Array (5:09)
6. Populate Row With Array (3:21)
7. Array Length (6:47)
8. Split String Into An Array (4:28)
9. Join Array Into A String (3:49)
Work with Dates
Source Files
1. Topics Overview (1:12)
2. Delay A Procedure (4:12)
3. Schedule A Procedure (4:18)
4. Count Years (5:20)
5. Count Days Between Dates (2:42)
6. Count Weekdays Between Dates (4:51)
7. Sort Dates (6:27)
Application Object
Source Files
1. Topics Overview (1:36)
2. How To Access Excel Functions (4:28)
3. Disable Screen Updating (3:19)
4. Disable Alerts (3:38)
5. Show Progress Of Macro (6:35)
6. Read Data From A File (6:35)
7. Write Data To A File (5:10)
VBA Projects
Source Files
1. Topics Overview (0:52)
2. Build A Table (4:47)
3. Build A Table Of Contents (11:47)
4. Build A Table Of Contents 2 (4:42)
5. Combine Worksheets (17:42)
6. Combine Worksheets By Column (15:49)
Programming Charts
Source Files
1. Topics Overview (1:20)
2. Program A Chart (6:12)
3. Program An Embedded Chart (4:59)
4. Delete Charts Programmatically (2:19)
2. How To Save Macros
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock