Visual Basic for Applications – Table of Contents

Basics Length
Introduction setup and VB editor 04:27
Variables 09:05
Constants and For Next statement 05:18
Msgbox, ampersand, underscore, operators and parentheses 05:04
Arrays Length
Arrays and Ucase, Lcase 06:16
Dynamic arrays, Redim Preserve and Lbound, Ubound 07:33
N-dimensional arrays, part 1 09:16
N-dimensional arrays, part 2 08:06
N-dimensional arrays, part 3 07:43
Workbooks and worksheets Length
Workbooks 08:36
Worksheets 07:38
Objects Length
Excels object model 06:01
Range object 18:02
Offset property 04:51
Cells property 05:23
Misc Length
With – End With statement and If function 09:53
Select case and For Next statement 05:14
Do While – Do Until 05:14
Call a macro inside another macro 04:14
Copy a cell range – Move a cell range 03:17
Dialog boxes Length
Video 1 06:37
Video 2 08:27
Video 3 08:01
Video 4 08:27
Custom functions Length
Video 1 07:47
Video 2 17:31
Debugging tools Length
Debugging tools 16:09
Userforms Length
Video 1 16:37
Video 2 13:19
Video 3 12:37
Video 4 08:12
Video 5 04:16
Video 6 15:29
Video 7 17:37
Macros Length
Video 1 05:51
Advanced userform example Length
Video 1 20:58
Video 2 18:47
Video 3 21:52
Custom functions Length
Video 1 21:10
Video 2 18:39
Video 3 27:00
Pivot tables Length
Video 1 11:45
Video 2 15:30
Video 3 5:49
Video 4 2:38
Video 5 8:00
Video 6 5:47
Video 7 8:41
Video 8 8:14
Video 9 6:04
Video 10 7:11
Video 11 6:44
Video 12 5:05
Video 13 10:27
Charts Length
Video 1 12:42
Video 2 11:22
Video 3 11:54
Video 4 10:45
Misc Length
Application Caller 19:37
Intersect method 10:18
Regular expressions 29:05
Excel events Length
Workbook events, part 1 17:56
Workbook events, part 2 17:56
Worksheet events 15:16
Working with files Length
Video 1 4:53
Video 2 4:09
Video 3 4:10
Video 4 05:13
Video 5 04:52
Video 6 22:00
Video 7 12:43
Video 8 05:40
Manipulating text files Length
Video 1 04:10
Video 2 06:04
Video 3 09:01
VBA functions Length
Application Transpose 11:07
Application Transpose - Array 11:07