|
|
1. About the author-en_US.srt
|
SRT
|
1.8 KB
|
|
|
1. About the author.mp4
|
MP4
|
4.1 MB
|
|
|
1. Arrays fixed size Arrays-en_US.srt
|
SRT
|
4 KB
|
|
|
1. Arrays fixed size Arrays.mp4
|
MP4
|
15.1 MB
|
|
|
1. Final Example prepare the routines-en_US.srt
|
SRT
|
8.6 KB
|
|
|
1. Final Example prepare the routines.mp4
|
MP4
|
35.2 MB
|
|
|
1. Manage errors-en_US.srt
|
SRT
|
3.8 KB
|
|
|
1. Manage errors.mp4
|
MP4
|
12.9 MB
|
|
|
1. The Loop For .. Next and For each ...Next-en_US.srt
|
SRT
|
5.9 KB
|
|
|
1. The Loop For .. Next and For each ...Next.mp4
|
MP4
|
23.9 MB
|
|
|
1. The UserForms-en_US.srt
|
SRT
|
3.6 KB
|
|
|
1. The UserForms.mp4
|
MP4
|
10.5 MB
|
|
|
1. The VBA Project structure and composition-en_US.srt
|
SRT
|
3 KB
|
|
|
1. The VBA Project structure and composition.mp4
|
MP4
|
8 MB
|
|
|
1. The Workbook object-en_US.srt
|
SRT
|
3.5 KB
|
|
|
1. The Workbook object.mp4
|
MP4
|
8.3 MB
|
|
|
1. Trigger Actions on Worksheets with buttons-en_US.srt
|
SRT
|
2.2 KB
|
|
|
1. Trigger Actions on Worksheets with buttons.mp4
|
MP4
|
8.7 MB
|
|
|
1. Variables and Constants-en_US.srt
|
SRT
|
2.1 KB
|
|
|
1. Variables and Constants.mp4
|
MP4
|
6.9 MB
|
|
|
1. Write to a text file-en_US.srt
|
SRT
|
4.1 KB
|
|
|
1. Write to a text file.mp4
|
MP4
|
16.1 MB
|
|
|
10. Modify the code of a recorded macro-en_US.srt
|
SRT
|
5.5 KB
|
|
|
10. Modify the code of a recorded macro.mp4
|
MP4
|
16.8 MB
|
|
|
10. MsgBox and InputBox Manage User Queries-en_US.srt
|
SRT
|
5 KB
|
|
|
10. MsgBox and InputBox Manage User Queries.mp4
|
MP4
|
19.3 MB
|
|
|
2. Arrays Array size-en_US.srt
|
SRT
|
2.7 KB
|
|
|
2. Arrays Array size.mp4
|
MP4
|
9.5 MB
|
|
|
2. Build a custom UserForm-en_US.srt
|
SRT
|
5 KB
|
|
|
2. Build a custom UserForm.mp4
|
MP4
|
18.3 MB
|
|
|
2. DropDowns on Worksheets to select pre-options-en_US.srt
|
SRT
|
1.6 KB
|
|
|
2. DropDowns on Worksheets to select pre-options.mp4
|
MP4
|
6.5 MB
|
|
|
2. Final Example view and format the results-en_US.srt
|
SRT
|
3.6 KB
|
|
|
2. Final Example view and format the results.mp4
|
MP4
|
14.2 MB
|
|
|
2. Ignore errors-en_US.srt
|
SRT
|
2.9 KB
|
|
|
2. Ignore errors.mp4
|
MP4
|
9.1 MB
|
|
|
2. Read from a text file-en_US.srt
|
SRT
|
4.4 KB
|
|
|
2. Read from a text file.mp4
|
MP4
|
19.2 MB
|
|
|
2. Subroutines and Functions-en_US.srt
|
SRT
|
2.3 KB
|
|
|
2. Subroutines and Functions.mp4
|
MP4
|
9.7 MB
|
|
|
2. The Loop While-en_US.srt
|
SRT
|
1.4 KB
|
|
|
2. The Loop While.mp4
|
MP4
|
5.6 MB
|
|
|
2. The Worksheet Module Code-en_US.srt
|
SRT
|
3.3 KB
|
|
|
2. The Worksheet Module Code.mp4
|
MP4
|
8.1 MB
|
|
|
2. The Worksheet object-en_US.srt
|
SRT
|
2.9 KB
|
|
|
2. The Worksheet object.mp4
|
MP4
|
8.6 MB
|
|
|
2. Why VBA-en_US.srt
|
SRT
|
6.2 KB
|
|
|
2. Why VBA.mp4
|
MP4
|
83.4 MB
|
|
|
3. Arrays variable size Arrays-en_US.srt
|
SRT
|
6.1 KB
|
|
|
3. Arrays variable size Arrays.mp4
|
MP4
|
18.8 MB
|
|
|
3. Customize the events and properties of commands in a UserForm-en_US.srt
|
SRT
|
4.8 KB
|
|
|
3. Customize the events and properties of commands in a UserForm.mp4
|
MP4
|
12.7 MB
|
|
|
3. Introduction-en_US.srt
|
SRT
|
2.6 KB
|
|
|
3. Introduction.mp4
|
MP4
|
8.5 MB
|
|
|
3. The Cell and Range objects-en_US.srt
|
SRT
|
3.5 KB
|
|
|
3. The Cell and Range objects.mp4
|
MP4
|
12.4 MB
|
|
|
3. The Loop Do Until-en_US.srt
|
SRT
|
1.6 KB
|
|
|
3. The Loop Do Until.mp4
|
MP4
|
5.6 MB
|
|
|
3. The Worksheet Properties-en_US.srt
|
SRT
|
3.8 KB
|
|
|
3. The Worksheet Properties.mp4
|
MP4
|
13.8 MB
|
|
|
3. Trigger actions with VBA controls on a Worksheet-en_US.srt
|
SRT
|
2.4 KB
|
|
|
3. Trigger actions with VBA controls on a Worksheet.mp4
|
MP4
|
11.5 MB
|
|
|
3. User Defined Functions-en_US.srt
|
SRT
|
1.4 KB
|
|
|
3. User Defined Functions.mp4
|
MP4
|
4.8 MB
|
|
|
3. Write to a binary file-en_US.srt
|
SRT
|
4 KB
|
|
|
3. Write to a binary file.mp4
|
MP4
|
14.5 MB
|
|
|
4. Collections-en_US.srt
|
SRT
|
2.8 KB
|
|
|
4. Collections.mp4
|
MP4
|
9.1 MB
|
|
|
4. Control the data in textboxes in a UserForm-en_US.srt
|
SRT
|
6.1 KB
|
|
|
4. Control the data in textboxes in a UserForm.mp4
|
MP4
|
20.9 MB
|
|
|
4. Filter data using VBA controls on a Worksheet (Part I)-en_US.srt
|
SRT
|
1.6 KB
|
|
|
4. Filter data using VBA controls on a Worksheet (Part I).mp4
|
MP4
|
9.8 MB
|
|
|
4. Read from a binary file-en_US.srt
|
SRT
|
4 KB
|
|
|
4. Read from a binary file.mp4
|
MP4
|
12.3 MB
|
|
|
4. The Conditional Instructions If, Else, ElseIF-en_US.srt
|
SRT
|
3.6 KB
|
|
|
4. The Conditional Instructions If, Else, ElseIF.mp4
|
MP4
|
13.2 MB
|
|
|
4. The Worksheet Methods-en_US.srt
|
SRT
|
2.2 KB
|
|
|
4. The Worksheet Methods.mp4
|
MP4
|
6.5 MB
|
|
|
4. The prerequisites the developer ribbon and the Excel file format-en_US.srt
|
SRT
|
4.2 KB
|
|
|
4. The prerequisites the developer ribbon and the Excel file format.mp4
|
MP4
|
10 MB
|
|
|
4. VBA Modules-en_US.srt
|
SRT
|
2.4 KB
|
|
|
4. VBA Modules.mp4
|
MP4
|
8.3 MB
|
|
|
5. Customize the properties and methods of button controls-en_US.srt
|
SRT
|
1.7 KB
|
|
|
5. Customize the properties and methods of button controls.mp4
|
MP4
|
5.2 MB
|
|
|
5. Filter data using VBA controls on a Worksheet (Part II)-en_US.srt
|
SRT
|
3.1 KB
|
|
|
5. Filter data using VBA controls on a Worksheet (Part II).mp4
|
MP4
|
17.2 MB
|
|
|
5. The Conditional Instructions Select Case-en_US.srt
|
SRT
|
1.3 KB
|
|
|
5. The Conditional Instructions Select Case.mp4
|
MP4
|
4.8 MB
|
|
|
5. The General variables and subroutines-en_US.srt
|
SRT
|
3.9 KB
|
|
|
5. The General variables and subroutines.mp4
|
MP4
|
13.2 MB
|
|
|
5. The Type Data Structure-en_US.srt
|
SRT
|
5.7 KB
|
|
|
5. The Type Data Structure.mp4
|
MP4
|
19.7 MB
|
|
|
5. The VBA Editor VBE-en_US.srt
|
SRT
|
7.6 KB
|
|
|
5. The VBA Editor VBE.mp4
|
MP4
|
18 MB
|
|
|
5. The Worksheet Module-en_US.srt
|
SRT
|
2.9 KB
|
|
|
5. The Worksheet Module.mp4
|
MP4
|
8 MB
|
|
|
6. Dynamically populate a combobox-en_US.srt
|
SRT
|
1.5 KB
|
|
|
6. Dynamically populate a combobox.mp4
|
MP4
|
5.6 MB
|
|
|
6. Improve the performances of subroutines of VBA controls on a Worksheet-en_US.srt
|
SRT
|
1.4 KB
|
|
|
6. Improve the performances of subroutines of VBA controls on a Worksheet.mp4
|
MP4
|
5.5 MB
|
|
|
6. Public and Private Subroutines and Functions-en_US.srt
|
SRT
|
5.8 KB
|
|
|
6. Public and Private Subroutines and Functions.mp4
|
MP4
|
22.6 MB
|
|
|
6. Strings and String Functions-en_US.srt
|
SRT
|
5.8 KB
|
|
|
6. Strings and String Functions.mp4
|
MP4
|
30.2 MB
|
|
|
6. The Workbook Methods-en_US.srt
|
SRT
|
2.4 KB
|
|
|
6. The Workbook Methods.mp4
|
MP4
|
8.1 MB
|
|
|
6. The concept of Macro-en_US.srt
|
SRT
|
2.5 KB
|
|
|
6. The concept of Macro.mp4
|
MP4
|
6.8 MB
|
|
|
7. Exchange Data between UserForms and Worksheets-en_US.srt
|
SRT
|
2.7 KB
|
|
|
7. Exchange Data between UserForms and Worksheets.mp4
|
MP4
|
9.8 MB
|
|
|
7. Public and Private Variables-en_US.srt
|
SRT
|
4.3 KB
|
|
|
7. Public and Private Variables.mp4
|
MP4
|
17.7 MB
|
|
|
7. Record a macro-en_US.srt
|
SRT
|
5.4 KB
|
|
|
7. Record a macro.mp4
|
MP4
|
14.1 MB
|
|
|
8. Macro Security-en_US.srt
|
SRT
|
4.7 KB
|
|
|
8. Macro Security.mp4
|
MP4
|
15 MB
|
|
|
8. MsgBox Customize your messages and warnings for the User-en_US.srt
|
SRT
|
2.5 KB
|
|
|
8. MsgBox Customize your messages and warnings for the User.mp4
|
MP4
|
7.6 MB
|
|
|
8. Variable Types and Declarations-en_US.srt
|
SRT
|
2.5 KB
|
|
|
8. Variable Types and Declarations.mp4
|
MP4
|
7.2 MB
|
|
|
9. MsgBox Customize the buttons of your message dialog-en_US.srt
|
SRT
|
921.6 B
|
|
|
9. MsgBox Customize the buttons of your message dialog.mp4
|
MP4
|
4.1 MB
|
|
|
9. Understand the recorded VBA code-en_US.srt
|
SRT
|
7.4 KB
|
|
|
9. Understand the recorded VBA code.mp4
|
MP4
|
24.4 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Exercise Create and find lists.html
|
HTML
|
716.8 B
|
|
|
Exercise Format a given Excel table.html
|
HTML
|
921.6 B
|
|
|
Exercise Merge Workbooks.html
|
HTML
|
1 KB
|
|
|
Exercise Retrieve the common elements.html
|
HTML
|
819.2 B
|
|
|
Exercise Save data into a CSV file.html
|
HTML
|
204.8 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
customers.xlsm
|
XLSM
|
57.3 KB
|
|
|
example-vba-01.xlsm
|
XLSM
|
24.4 KB
|
