Autoplay
Autocomplete
Previous Lesson
Complete and Continue
VBA Macros in Excel
Overview Course and Example Files
Overview Course (4:55)
Workshop Excel Files
Understanding VBA Syntax and Statements
Chapter1-1 | Recording Macros (25:52)
Chapter1-2 | Recording Macros (9:55)
Chapter1-3 | Recording Macros (10:29)
Chapter1-4 | Recording Macros (5:05)
Chapter1-5 | Recording Macros (8:19)
Chapter2 | Personal Macro (14:59)
Chapter3 | Introduction to VBA (13:22)
Chapter4-1| Variables and Data Types (13:31)
Chapter4-2| Variables and Data Types (8:14)
Chapter4-3| Variables and Data Types (6:47)
Chapter4-4| Variables and Data Types (1:19)
Chapter4-5| Variables and Data Types (4:47)
Chapter5-1 | Range and Worksheet Reference (13:22)
Chapter5-2 | Range and Worksheet Reference (11:23)
Chapter6 | Debugging VBA Code (6:46)
Chapter7 | Object Property and Method in VBA (8:09)
Chapter8 | With and End with Statement (1:36)
Chapter9-1| For...Next...Statement (6:40)
Chapter9-2 | For...Next...Statement (7:29)
Chapter9-3 | For...Next...Statement (5:10)
Chapter9-4 | For...Next...Statement (11:43)
Chapter9-5 | For...Next...Statement (9:32)
Chapter9-6 | For...Next...Statement (6:15)
Chapter9-7 | For...Next...Statement (9:27)
Chapter9-8 | For...Next...Statment (8:33)
Chapter10-1 | IF...Then...Else...Statement (10:30)
Chapter10-2 | IF...Then...Else...Statement (9:32)
Chapter10-3 | IF...Then...Else...Statement (12:18)
Chapter11-1 | Select...Case...Statement (5:57)
Chapter11-2 | Select...Case...Statement (11:56)
Chapter12-1 | Do...Loop...Statement (8:44)
Chapter12-2 | Do...Loop...Statement (8:44)
Chapter12-3 | Do...Loop...Statement (6:44)
Chapter12-4 | Do...Loop...Statement (12:25)
Chapter13 | CALL Statement (4:53)
Chapter14 | Msgbox and InputBox (7:44)
Chapter15 | Array (27:01)
Workshop | Review Chapter 1 to 15
Case1 (9:13)
Case2 (10:30)
Workbook , Worksheet and Range Automation
Chapter16-1 | Working with Range (22:44)
Chapter16-2 | Working with Range (14:15)
Chapter16-3 | Working with Range (4:09)
Chapter17-1 | Working with Worksheets (11:29)
Chapter17-2 | Working with Worksheets (8:30)
Chapter17-3 | Working with Worksheets (14:43)
Chapter17-4 | Working with Worksheets (14:15)
Chapter18-1 | Working with Workbooks (19:40)
Chapter18-2 | Working with Workbooks (12:41)
Chapter18-3 | Working with Workbooks (11:19)
Chapter19 | Using Excel Built-in Functions in VBA (5:26)
Chapter20 | AUTO_OPEN and AUTO_CLOSE Procedure (3:19)
Chapter21-1 | For...Each...Statement (4:58)
Chapter21-2 | For...Each...Statement (8:04)
Chapter21-3 | For...Each...Statement (7:50)
Workshop | Review Chapter 16 to 21
Case1 (11:10)
Case2-1 (17:18)
Case2-2 (7:41)
Case2-3 (5:18)
Files and Folders Automation
Chapter22-Error Handling in VBA (13:01)
Chapter23-1 | Working with Folders (16:53)
Chapter23-2 | Working with Folders (11:33)
Chapter23-3 | Working with Folders (10:53)
Chapter23-4 | Working with Folders (12:45)
Chapter23-5 | Working with Folders (14:59)
Chapter23-6 | Working with Folders (3:32)
Chapter24 | Files and Folders Handling with VBA (9:14)
Chapter25 | Creating Macros can run anywhere (10:33)
Chapter26-1 | Excel Event Programming (9:39)
Chapter26-2 | Excel Event Programming (4:32)
Chapter26-3 | Excel Event Programming (2:43)
Chapter26-4 | Excel Event Programming (2:31)
Chapter26-5 | Excel Event Programming (5:13)
Email Automation and PivotTable
Chapter27 | Sending Email with VBA (4:42)
Chapter28 | Creating PivotTable with VBA (11:06)
Workshop | Review Chapter 19 to 28
Case1 (11:22)
Case2 (10:16)
Post-Test
Post-Test
Chapter20 | AUTO_OPEN and AUTO_CLOSE Procedure
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock