|
|
1. Configuring the Days Section.mp4
|
MP4
|
42.4 MB
|
|
|
1. Configuring the Days Section.srt
|
SRT
|
4.3 KB
|
|
|
1. Introduction.mp4
|
MP4
|
13.8 MB
|
|
|
1. Introduction.srt
|
SRT
|
2.2 KB
|
|
|
1. Source File (Developer Environment).html
|
HTML
|
102.4 B
|
|
|
1. Using RGB function to set colours.mp4
|
MP4
|
45.6 MB
|
|
|
1. Using RGB function to set colours.srt
|
SRT
|
7.6 KB
|
|
|
1. Welcome.mp4
|
MP4
|
17.4 MB
|
|
|
1. Welcome.srt
|
SRT
|
2.1 KB
|
|
|
1. What's the Best Approach to Learning Excel VBA.mp4
|
MP4
|
57.6 MB
|
|
|
1. What's the Best Approach to Learning Excel VBA.srt
|
SRT
|
8.3 KB
|
|
|
1.1 Date Picker.xlsm
|
XLSM
|
13.9 KB
|
|
|
2. Eliminating Redundancy.mp4
|
MP4
|
29.2 MB
|
|
|
2. Eliminating Redundancy.srt
|
SRT
|
4.9 KB
|
|
|
2. Introducing the Code Editor.mp4
|
MP4
|
44.6 MB
|
|
|
2. Introducing the Code Editor.srt
|
SRT
|
8.5 KB
|
|
|
2. Learning from the Windows Calendar.mp4
|
MP4
|
16.5 MB
|
|
|
2. Learning from the Windows Calendar.srt
|
SRT
|
3.1 KB
|
|
|
2. Recommended Learning Procedure.mp4
|
MP4
|
14 MB
|
|
|
2. Recommended Learning Procedure.srt
|
SRT
|
1.9 KB
|
|
|
2. Saving a Macro-Enabled Workbook.mp4
|
MP4
|
24.8 MB
|
|
|
2. Saving a Macro-Enabled Workbook.srt
|
SRT
|
3.8 KB
|
|
|
2. Setting the Default Properties of the Label R1C1.mp4
|
MP4
|
16.7 MB
|
|
|
2. Setting the Default Properties of the Label R1C1.srt
|
SRT
|
2.1 KB
|
|
|
2. Source File (Designing the Date Picker).html
|
HTML
|
102.4 B
|
|
|
2. What's Covered in this course.mp4
|
MP4
|
41.3 MB
|
|
|
2. What's Covered in this course.srt
|
SRT
|
5.7 KB
|
|
|
2. Working with Constants - Procedure Level.mp4
|
MP4
|
41.3 MB
|
|
|
2. Working with Constants - Procedure Level.srt
|
SRT
|
5.9 KB
|
|
|
2.1 Date Picker.xlsm
|
XLSM
|
16.3 KB
|
|
|
3. Adding the Developer Tab.mp4
|
MP4
|
24.9 MB
|
|
|
3. Adding the Developer Tab.srt
|
SRT
|
3.1 KB
|
|
|
3. Designing the Header – Marking Boundary.mp4
|
MP4
|
51.1 MB
|
|
|
3. Designing the Header – Marking Boundary.srt
|
SRT
|
6.2 KB
|
|
|
3. Setting the Default Properties of the 1st Row.mp4
|
MP4
|
36.2 MB
|
|
|
3. Setting the Default Properties of the 1st Row.srt
|
SRT
|
5.5 KB
|
|
|
3. Source File (VBA Coding).html
|
HTML
|
102.4 B
|
|
|
3. The Looping Technique.mp4
|
MP4
|
45.9 MB
|
|
|
3. The Looping Technique.srt
|
SRT
|
7.3 KB
|
|
|
3. The downside of a procedure-level constant.mp4
|
MP4
|
11.1 MB
|
|
|
3. The downside of a procedure-level constant.srt
|
SRT
|
1.8 KB
|
|
|
3. Understanding the Initialize Event.mp4
|
MP4
|
57.3 MB
|
|
|
3. Understanding the Initialize Event.srt
|
SRT
|
10.4 KB
|
|
|
3. What is VBA.mp4
|
MP4
|
40 MB
|
|
|
3. What is VBA.srt
|
SRT
|
6.3 KB
|
|
|
3.1 Date Picker .xlsm
|
XLSM
|
19 KB
|
|
|
4. Accessing the Controls Collection.mp4
|
MP4
|
40 MB
|
|
|
4. Accessing the Controls Collection.srt
|
SRT
|
5.7 KB
|
|
|
4. Accessing the VBA Editor.mp4
|
MP4
|
11.1 MB
|
|
|
4. Accessing the VBA Editor.srt
|
SRT
|
1.2 KB
|
|
|
4. Designing the Header - Month Display.mp4
|
MP4
|
51.7 MB
|
|
|
4. Designing the Header - Month Display.srt
|
SRT
|
5.8 KB
|
|
|
4. Important Word - Before we begin.html
|
HTML
|
2.4 KB
|
|
|
4. Nested Loop Statements.mp4
|
MP4
|
26.2 MB
|
|
|
4. Nested Loop Statements.srt
|
SRT
|
3.8 KB
|
|
|
4. Source File (Enabling the Top Navigation).html
|
HTML
|
102.4 B
|
|
|
4. Understanding the initialize event - Continued….mp4
|
MP4
|
58.1 MB
|
|
|
4. Understanding the initialize event - Continued….srt
|
SRT
|
9.3 KB
|
|
|
4. Working with Constants - Module Level.mp4
|
MP4
|
11.8 MB
|
|
|
4. Working with Constants - Module Level.srt
|
SRT
|
1.5 KB
|
|
|
4.1 Important Word - Before we begin - Spanish.docx
|
DOCX
|
13.8 KB
|
|
|
5. Adding more constants.mp4
|
MP4
|
40.6 MB
|
|
|
5. Adding more constants.srt
|
SRT
|
6.8 KB
|
|
|
5. Designing the Header - Year Display.mp4
|
MP4
|
39.2 MB
|
|
|
5. Designing the Header - Year Display.srt
|
SRT
|
3.8 KB
|
|
|
5. Enabling the Dynamic Top Row Position.mp4
|
MP4
|
9.8 MB
|
|
|
5. Enabling the Dynamic Top Row Position.srt
|
SRT
|
1 KB
|
|
|
5. Indirect Referencing of Labels.mp4
|
MP4
|
26.7 MB
|
|
|
5. Indirect Referencing of Labels.srt
|
SRT
|
3.5 KB
|
|
|
5. Source File (The Date Display Defaults - Nested Loops).html
|
HTML
|
102.4 B
|
|
|
5. Understanding the VBA Editor.mp4
|
MP4
|
20.1 MB
|
|
|
5. Understanding the VBA Editor.srt
|
SRT
|
3.5 KB
|
|
|
5. Working With the Properties of Child Objects.mp4
|
MP4
|
63.3 MB
|
|
|
5. Working With the Properties of Child Objects.srt
|
SRT
|
8.8 KB
|
|
|
6. Adding a UserForm.mp4
|
MP4
|
7 MB
|
|
|
6. Adding a UserForm.srt
|
SRT
|
819.2 B
|
|
|
6. Adding and Calling Private Sub Procedures.mp4
|
MP4
|
45.5 MB
|
|
|
6. Adding and Calling Private Sub Procedures.srt
|
SRT
|
7.4 KB
|
|
|
6. Adding the Days Section.mp4
|
MP4
|
54 MB
|
|
|
6. Adding the Days Section.srt
|
SRT
|
6.3 KB
|
|
|
6. Dynamically Updating the Left Position.mp4
|
MP4
|
15.1 MB
|
|
|
6. Dynamically Updating the Left Position.srt
|
SRT
|
2.2 KB
|
|
|
6. Module - Summary.mp4
|
MP4
|
12.9 MB
|
|
|
6. Module - Summary.srt
|
SRT
|
1.7 KB
|
|
|
6. Working with Constants - Enumeration.mp4
|
MP4
|
40 MB
|
|
|
6. Working with Constants - Enumeration.srt
|
SRT
|
6.2 KB
|
|
|
7. Adding the Date Section.mp4
|
MP4
|
73.7 MB
|
|
|
7. Adding the Date Section.srt
|
SRT
|
9.3 KB
|
|
|
7. Arranging Display - Separation of Concerns.mp4
|
MP4
|
47.2 MB
|
|
|
7. Arranging Display - Separation of Concerns.srt
|
SRT
|
7.3 KB
|
|
|
7. Course Summary & Conclusion.mp4
|
MP4
|
35.3 MB
|
|
|
7. Course Summary & Conclusion.srt
|
SRT
|
4.8 KB
|
|
|
7. Event Procedures & User-Defined Procedures.mp4
|
MP4
|
23.3 MB
|
|
|
7. Event Procedures & User-Defined Procedures.srt
|
SRT
|
3.4 KB
|
|
|
7. Testing the Left Position.mp4
|
MP4
|
26.8 MB
|
|
|
7. Testing the Left Position.srt
|
SRT
|
4.6 KB
|
|
|
7. The Toolbox.mp4
|
MP4
|
11.1 MB
|
|
|
7. The Toolbox.srt
|
SRT
|
1.3 KB
|
|
|
8. Adding the Footer.mp4
|
MP4
|
51.9 MB
|
|
|
8. Adding the Footer.srt
|
SRT
|
7.3 KB
|
|
|
8. Coding the Days Captions.mp4
|
MP4
|
28 MB
|
|
|
8. Coding the Days Captions.srt
|
SRT
|
4.3 KB
|
|
|
8. Header Settings - Month Display.mp4
|
MP4
|
36.4 MB
|
|
|
8. Header Settings - Month Display.srt
|
SRT
|
4.2 KB
|
|
|
8. Link to Part 2 of the Beginner ‘s Guide to Excel VBA.html
|
HTML
|
614.4 B
|
|
|
8. The Properties Window.mp4
|
MP4
|
23.1 MB
|
|
|
8. The Properties Window.srt
|
SRT
|
2.5 KB
|
|
|
9. Header Settings - Year Display.mp4
|
MP4
|
39.5 MB
|
|
|
9. Header Settings - Year Display.srt
|
SRT
|
5.4 KB
|
|
|
9. Test Driving the Properties Window.mp4
|
MP4
|
23.5 MB
|
|
|
9. Test Driving the Properties Window.srt
|
SRT
|
2.9 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Date Picker - Enabling the Top Navigation.xlsm
|
XLSM
|
24.9 KB
|
|
|
Date Picker - The Date Display Defaults - Nested Loops.xlsm
|
XLSM
|
20.7 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
