|
|
1. Error Trapping the Easy Way.mp4
|
MP4
|
5.2 MB
|
|
|
1. Error Trapping the Easy Way.srt
|
SRT
|
12.7 KB
|
|
|
1. How To Create An Event.mp4
|
MP4
|
4.5 MB
|
|
|
1. How To Create An Event.srt
|
SRT
|
11.6 KB
|
|
|
1. Recording And Running A Simple Macro.mp4
|
MP4
|
2.8 MB
|
|
|
1. Recording And Running A Simple Macro.srt
|
SRT
|
6.9 KB
|
|
|
1. Referencing Cells Using The Range Object.mp4
|
MP4
|
3 MB
|
|
|
1. Referencing Cells Using The Range Object.srt
|
SRT
|
8.4 KB
|
|
|
1. So What's Next.mp4
|
MP4
|
1.3 MB
|
|
|
1. So What's Next.srt
|
SRT
|
4.2 KB
|
|
|
1. Trigger A Procedure From The Quick Access Toolbar.mp4
|
MP4
|
4.1 MB
|
|
|
1. Trigger A Procedure From The Quick Access Toolbar.srt
|
SRT
|
8.2 KB
|
|
|
1. Using Comments Within Your VBA Code.mp4
|
MP4
|
2.4 MB
|
|
|
1. Using Comments Within Your VBA Code.srt
|
SRT
|
7.7 KB
|
|
|
1. Using GOTO And Labels.mp4
|
MP4
|
2.6 MB
|
|
|
1. Using GOTO And Labels.srt
|
SRT
|
7 KB
|
|
|
1. Using MSGBOX To Interact With Users.mp4
|
MP4
|
6.1 MB
|
|
|
1. Using MSGBOX To Interact With Users.srt
|
SRT
|
13.9 KB
|
|
|
1. What Is A Function.mp4
|
MP4
|
1.1 MB
|
|
|
1. What Is A Function.srt
|
SRT
|
2.6 KB
|
|
|
1. What Is A Module.mp4
|
MP4
|
2.2 MB
|
|
|
1. What Is A Module.srt
|
SRT
|
6.6 KB
|
|
|
1. Working Files - Download These First.html
|
HTML
|
0 B
|
|
|
1.1 Learning Visual Basic For Microsoft Excel Working Files.zip
|
ZIP
|
1.5 MB
|
|
|
10. Common METHODS Of The RANGE Object.mp4
|
MP4
|
7.7 MB
|
|
|
10. Common METHODS Of The RANGE Object.srt
|
SRT
|
18.2 KB
|
|
|
10. Multi-Dimensional Arrays.mp4
|
MP4
|
2 MB
|
|
|
10. Multi-Dimensional Arrays.srt
|
SRT
|
5.6 KB
|
|
|
10. UserForm Controls - The CheckBox.mp4
|
MP4
|
6.2 MB
|
|
|
10. UserForm Controls - The CheckBox.srt
|
SRT
|
12.7 KB
|
|
|
11. Dynamic Arrays.mp4
|
MP4
|
1.9 MB
|
|
|
11. Dynamic Arrays.srt
|
SRT
|
6.7 KB
|
|
|
11. UserForm Controls - ListBox AndOr Combo Box.mp4
|
MP4
|
8 MB
|
|
|
11. UserForm Controls - ListBox AndOr Combo Box.srt
|
SRT
|
14.6 KB
|
|
|
12. Images On UserForms.mp4
|
MP4
|
4.4 MB
|
|
|
12. Images On UserForms.srt
|
SRT
|
9.2 KB
|
|
|
13. Labels And Text Boxes.mp4
|
MP4
|
4.1 MB
|
|
|
13. Labels And Text Boxes.srt
|
SRT
|
8.7 KB
|
|
|
14. Multiple Tabs On A UserForm.mp4
|
MP4
|
6.4 MB
|
|
|
14. Multiple Tabs On A UserForm.srt
|
SRT
|
12.2 KB
|
|
|
15. Allowing The User To Highlight A Range.mp4
|
MP4
|
3.2 MB
|
|
|
15. Allowing The User To Highlight A Range.srt
|
SRT
|
6.3 KB
|
|
|
16. Scrollbar And Spin Controls.mp4
|
MP4
|
6 MB
|
|
|
16. Scrollbar And Spin Controls.srt
|
SRT
|
13.1 KB
|
|
|
17. Controlling Tab Order And Aligning Controls.mp4
|
MP4
|
8.2 MB
|
|
|
17. Controlling Tab Order And Aligning Controls.srt
|
SRT
|
14.7 KB
|
|
|
2. Built In VBA Date Functions.mp4
|
MP4
|
1.6 MB
|
|
|
2. Built In VBA Date Functions.srt
|
SRT
|
4.2 KB
|
|
|
2. Controlling The Program Flow With IF THEN ELSE.mp4
|
MP4
|
2.5 MB
|
|
|
2. Controlling The Program Flow With IF THEN ELSE.srt
|
SRT
|
7.2 KB
|
|
|
2. Creating A Sub Procedure Manually.mp4
|
MP4
|
2 MB
|
|
|
2. Creating A Sub Procedure Manually.srt
|
SRT
|
6 KB
|
|
|
2. Customizing The Ribbons.mp4
|
MP4
|
4.6 MB
|
|
|
2. Customizing The Ribbons.srt
|
SRT
|
8.2 KB
|
|
|
2. Declaring Variables And Data Types.mp4
|
MP4
|
3.8 MB
|
|
|
2. Declaring Variables And Data Types.srt
|
SRT
|
9.9 KB
|
|
|
2. Editing An Existing Macro In The Visual Basic Editor.mp4
|
MP4
|
3.1 MB
|
|
|
2. Editing An Existing Macro In The Visual Basic Editor.srt
|
SRT
|
7.2 KB
|
|
|
2. Make The VBA Ignore Errors.mp4
|
MP4
|
3 MB
|
|
|
2. Make The VBA Ignore Errors.srt
|
SRT
|
6.8 KB
|
|
|
2. The CELLS Property.mp4
|
MP4
|
1.8 MB
|
|
|
2. The CELLS Property.srt
|
SRT
|
4.7 KB
|
|
|
2. Use INPUTBOX For Accepting Values From Users.mp4
|
MP4
|
4.7 MB
|
|
|
2. Use INPUTBOX For Accepting Values From Users.srt
|
SRT
|
11.8 KB
|
|
|
2. What Will I Get Out Of This Course.mp4
|
MP4
|
2.1 MB
|
|
|
2. What Will I Get Out Of This Course.srt
|
SRT
|
7.8 KB
|
|
|
2. WorkBook Events - Open.mp4
|
MP4
|
6.3 MB
|
|
|
2. WorkBook Events - Open.srt
|
SRT
|
12.5 KB
|
|
|
3. Adding Buttons To Sheets.mp4
|
MP4
|
2.9 MB
|
|
|
3. Adding Buttons To Sheets.srt
|
SRT
|
5.8 KB
|
|
|
3. How To Call A Sub Procedure.mp4
|
MP4
|
2.1 MB
|
|
|
3. How To Call A Sub Procedure.srt
|
SRT
|
5.1 KB
|
|
|
3. Interact With The User When An Error Occurs.mp4
|
MP4
|
3.3 MB
|
|
|
3. Interact With The User When An Error Occurs.srt
|
SRT
|
8.6 KB
|
|
|
3. Multiple Criteria Plus Nested IFs.mp4
|
MP4
|
3.6 MB
|
|
|
3. Multiple Criteria Plus Nested IFs.srt
|
SRT
|
9.2 KB
|
|
|
3. Selecting A Range With The INPUT Box.mp4
|
MP4
|
2.4 MB
|
|
|
3. Selecting A Range With The INPUT Box.srt
|
SRT
|
6.2 KB
|
|
|
3. Text Manipulation With VBA Functions.mp4
|
MP4
|
2.6 MB
|
|
|
3. Text Manipulation With VBA Functions.srt
|
SRT
|
6.2 KB
|
|
|
3. The Excel Working Files Explained.mp4
|
MP4
|
2.1 MB
|
|
|
3. The Excel Working Files Explained.srt
|
SRT
|
6.3 KB
|
|
|
3. The New Macro Enabled File Type.mp4
|
MP4
|
1.9 MB
|
|
|
3. The New Macro Enabled File Type.srt
|
SRT
|
4.1 KB
|
|
|
3. The OFFSET Property.mp4
|
MP4
|
1.5 MB
|
|
|
3. The OFFSET Property.srt
|
SRT
|
4.3 KB
|
|
|
3. The Scope Of A Variable.mp4
|
MP4
|
3.1 MB
|
|
|
3. The Scope Of A Variable.srt
|
SRT
|
7.8 KB
|
|
|
3. Workbook Events - Closing And Saving.mp4
|
MP4
|
5.6 MB
|
|
|
3. Workbook Events - Closing And Saving.srt
|
SRT
|
10.5 KB
|
|
|
4. Adding A Keyboard Shortcut Trigger.mp4
|
MP4
|
2 MB
|
|
|
4. Adding A Keyboard Shortcut Trigger.srt
|
SRT
|
4.7 KB
|
|
|
4. Adding ELSEIF To Speed Up Execution.mp4
|
MP4
|
2.6 MB
|
|
|
4. Adding ELSEIF To Speed Up Execution.srt
|
SRT
|
7.1 KB
|
|
|
4. An Introduction To UserForms.mp4
|
MP4
|
3 MB
|
|
|
4. An Introduction To UserForms.srt
|
SRT
|
7 KB
|
|
|
4. Creating A Function Procedure.mp4
|
MP4
|
1.7 MB
|
|
|
4. Creating A Function Procedure.srt
|
SRT
|
5.3 KB
|
|
|
4. Determining File Sizes Using FILELEN.mp4
|
MP4
|
1.7 MB
|
|
|
4. Determining File Sizes Using FILELEN.srt
|
SRT
|
3.6 KB
|
|
|
4. Making Use Of The ERR Object.mp4
|
MP4
|
3 MB
|
|
|
4. Making Use Of The ERR Object.srt
|
SRT
|
6.3 KB
|
|
|
4. Quick Tour Of The Excel Visual Basic Editor.mp4
|
MP4
|
3.9 MB
|
|
|
4. Quick Tour Of The Excel Visual Basic Editor.srt
|
SRT
|
11.3 KB
|
|
|
4. The Static Declaration And Variable Expiry.mp4
|
MP4
|
3.3 MB
|
|
|
4. The Static Declaration And Variable Expiry.srt
|
SRT
|
9.5 KB
|
|
|
4. The VALUE Of Ranges.mp4
|
MP4
|
4.9 MB
|
|
|
4. The VALUE Of Ranges.srt
|
SRT
|
12.4 KB
|
|
|
4. What Is VBA For Excel.mp4
|
MP4
|
2.6 MB
|
|
|
4. What Is VBA For Excel.srt
|
SRT
|
10.8 KB
|
|
|
4. Workbook Triggers - Activate And Deactivate.mp4
|
MP4
|
3.8 MB
|
|
|
4. Workbook Triggers - Activate And Deactivate.srt
|
SRT
|
7.7 KB
|
|
|
5. Constants Instead Of Variables.mp4
|
MP4
|
2.2 MB
|
|
|
5. Constants Instead Of Variables.srt
|
SRT
|
6.1 KB
|
|
|
5. Creating A UserForm.mp4
|
MP4
|
3.4 MB
|
|
|
5. Creating A UserForm.srt
|
SRT
|
7 KB
|
|
|
5. Debugging Techniques.mp4
|
MP4
|
4 MB
|
|
|
5. Debugging Techniques.srt
|
SRT
|
9.6 KB
|
|
|
5. Excel 2010 Security Settings And Macro Files.mp4
|
MP4
|
2.9 MB
|
|
|
5. Excel 2010 Security Settings And Macro Files.srt
|
SRT
|
6.9 KB
|
|
|
5. How To Call A Function.mp4
|
MP4
|
2.2 MB
|
|
|
5. How To Call A Function.srt
|
SRT
|
4.9 KB
|
|
|
5. SELECT CASE As An Alternative To IF.mp4
|
MP4
|
2.9 MB
|
|
|
5. SELECT CASE As An Alternative To IF.srt
|
SRT
|
7.1 KB
|
|
|
5. The TEXT Object Of The RANGE.mp4
|
MP4
|
1.9 MB
|
|
|
5. The TEXT Object Of The RANGE.srt
|
SRT
|
4.8 KB
|
|
|
5. Using Worksheet Excel Functions In VBA Code.mp4
|
MP4
|
5.4 MB
|
|
|
5. Using Worksheet Excel Functions In VBA Code.srt
|
SRT
|
13.4 KB
|
|
|
5. Watch A Macro Write Your VBA.mp4
|
MP4
|
2.6 MB
|
|
|
5. Watch A Macro Write Your VBA.srt
|
SRT
|
5.3 KB
|
|
|
5. Where To Store Your VBA Code.mp4
|
MP4
|
5.5 MB
|
|
|
5. Where To Store Your VBA Code.srt
|
SRT
|
12.8 KB
|
|
|
5. Worksheet Triggers - Activate And Deactivate.mp4
|
MP4
|
2.8 MB
|
|
|
5. Worksheet Triggers - Activate And Deactivate.srt
|
SRT
|
5.7 KB
|
|
|
6. A Number Of Read Only RANGE Properties.mp4
|
MP4
|
5.5 MB
|
|
|
6. A Number Of Read Only RANGE Properties.srt
|
SRT
|
14 KB
|
|
|
6. Adding Code To The PERSONAL File.mp4
|
MP4
|
6 MB
|
|
|
6. Adding Code To The PERSONAL File.srt
|
SRT
|
12.8 KB
|
|
|
6. An Intrinsic Constant.mp4
|
MP4
|
2.1 MB
|
|
|
6. An Intrinsic Constant.srt
|
SRT
|
5.3 KB
|
|
|
6. Other Useful Worksheet Triggers.mp4
|
MP4
|
6.5 MB
|
|
|
6. Other Useful Worksheet Triggers.srt
|
SRT
|
15.4 KB
|
|
|
6. The Developer Ribbon.mp4
|
MP4
|
1.7 MB
|
|
|
6. The Developer Ribbon.srt
|
SRT
|
3.2 KB
|
|
|
6. The FOR NEXT Loop.mp4
|
MP4
|
5.7 MB
|
|
|
6. The FOR NEXT Loop.srt
|
SRT
|
16.1 KB
|
|
|
6. User Defined Functions In Excel.mp4
|
MP4
|
3 MB
|
|
|
6. User Defined Functions In Excel.srt
|
SRT
|
7 KB
|
|
|
6. Using Breakpoints To Help Debug.mp4
|
MP4
|
4 MB
|
|
|
6. Using Breakpoints To Help Debug.srt
|
SRT
|
9.4 KB
|
|
|
6. Using Command Buttons In Excel.mp4
|
MP4
|
3.8 MB
|
|
|
6. Using Command Buttons In Excel.srt
|
SRT
|
8.6 KB
|
|
|
7. Adding Option Buttons In A Frame.mp4
|
MP4
|
4 MB
|
|
|
7. Adding Option Buttons In A Frame.srt
|
SRT
|
7.4 KB
|
|
|
7. FOR NEXT With A VBA Collection.mp4
|
MP4
|
4.2 MB
|
|
|
7. FOR NEXT With A VBA Collection.srt
|
SRT
|
9.8 KB
|
|
|
7. Setup And Use A Watch.mp4
|
MP4
|
3.6 MB
|
|
|
7. Setup And Use A Watch.srt
|
SRT
|
8.2 KB
|
|
|
7. String And Date Types Expanded.mp4
|
MP4
|
3.6 MB
|
|
|
7. String And Date Types Expanded.srt
|
SRT
|
9.7 KB
|
|
|
7. The FONT Property And Colors.mp4
|
MP4
|
5.2 MB
|
|
|
7. The FONT Property And Colors.srt
|
SRT
|
13.6 KB
|
|
|
7. Using Application Events.mp4
|
MP4
|
9 MB
|
|
|
7. Using Application Events.srt
|
SRT
|
19.3 KB
|
|
|
8. Adding The Code That Makes The Form Work.mp4
|
MP4
|
5.3 MB
|
|
|
8. Adding The Code That Makes The Form Work.srt
|
SRT
|
11 KB
|
|
|
8. DO WHILE Loop.mp4
|
MP4
|
4.2 MB
|
|
|
8. DO WHILE Loop.srt
|
SRT
|
10.5 KB
|
|
|
8. Excel VBA Operators.mp4
|
MP4
|
5.3 MB
|
|
|
8. Excel VBA Operators.srt
|
SRT
|
13.4 KB
|
|
|
8. Formatting Numeric Values.mp4
|
MP4
|
2.4 MB
|
|
|
8. Formatting Numeric Values.srt
|
SRT
|
4.9 KB
|
|
|
8. Speeding Up The VBA Tips.mp4
|
MP4
|
9.7 MB
|
|
|
8. Speeding Up The VBA Tips.srt
|
SRT
|
20.1 KB
|
|
|
9. Add Formulas To Cells Through VBA Code.mp4
|
MP4
|
4.1 MB
|
|
|
9. Add Formulas To Cells Through VBA Code.srt
|
SRT
|
9.6 KB
|
|
|
9. Arrays.mp4
|
MP4
|
3 MB
|
|
|
9. Arrays.srt
|
SRT
|
8.4 KB
|
|
|
9. Calling Your UserForm And Validating Content.mp4
|
MP4
|
6.1 MB
|
|
|
9. Calling Your UserForm And Validating Content.srt
|
SRT
|
12.7 KB
|