[UDEMY] Visual Basic for Excel - Microsoft VBA Excel Tutorial.

Files:

• 8. Speeding Up The VBA Tips.mp4 (9.7 MB)
• 1. Error Trapping the Easy Way.mp4 (5.2 MB)
• 1. Error Trapping the Easy Way.srt (12.7 KB)
• 2. Make The VBA Ignore Errors.mp4 (3.0 MB)
• 2. Make The VBA Ignore Errors.srt (6.8 KB)
• 3. Interact With The User When An Error Occurs.mp4 (3.3 MB)
• 3. Interact With The User When An Error Occurs.srt (8.6 KB)
• 4. Making Use Of The ERR Object.mp4 (3.0 MB)
• 4. Making Use Of The ERR Object.srt (6.3 KB)
• 5. Debugging Techniques.mp4 (4.0 MB)
• 5. Debugging Techniques.srt (9.6 KB)
• 6. Using Breakpoints To Help Debug.mp4 (4.0 MB)
• 6. Using Breakpoints To Help Debug.srt (9.4 KB)
• 7. Setup And Use A Watch.mp4 (3.6 MB)
• 7. Setup And Use A Watch.srt (8.2 KB)
• 8. Speeding Up The VBA Tips.srt (20.1 KB)

• 1.1 Learning Visual Basic For Microsoft Excel Working Files.zip (1.5 MB)
• 2. What Will I Get Out Of This Course.mp4 (2.1 MB)
• 2. What Will I Get Out Of This Course.srt (7.8 KB)
• 3. The Excel Working Files Explained.mp4 (2.1 MB)
• 3. The Excel Working Files Explained.srt (6.3 KB)
• 4. What Is VBA For Excel.mp4 (2.6 MB)
• 4. What Is VBA For Excel.srt (10.8 KB)
• 5. Excel 2010 Security Settings And Macro Files.mp4 (2.9 MB)
• 5. Excel 2010 Security Settings And Macro Files.srt (6.9 KB)
• 6. The Developer Ribbon.mp4 (1.7 MB)
• 6. The Developer Ribbon.srt (3.2 KB)
• 1. Working Files - Download These First.html (0.0 KB)

• 1. Recording And Running A Simple Macro.mp4 (2.8 MB)
• 1. Recording And Running A Simple Macro.srt (6.9 KB)
• 2. Editing An Existing Macro In The Visual Basic Editor.mp4 (3.1 MB)
• 2. Editing An Existing Macro In The Visual Basic Editor.srt (7.2 KB)
• 3. The New Macro Enabled File Type.mp4 (1.9 MB)
• 3. The New Macro Enabled File Type.srt (4.1 KB)
• 4. Quick Tour Of The Excel Visual Basic Editor.mp4 (3.9 MB)
• 4. Quick Tour Of The Excel Visual Basic Editor.srt (11.3 KB)
• 5. Watch A Macro Write Your VBA.mp4 (2.6 MB)
• 5. Watch A Macro Write Your VBA.srt (5.3 KB)

• 1. What Is A Module.mp4 (2.2 MB)
• 1. What Is A Module.srt (6.6 KB)
• 2. Creating A Sub Procedure Manually.mp4 (2.0 MB)
• 2. Creating A Sub Procedure Manually.srt (6.0 KB)
• 3. How To Call A Sub Procedure.mp4 (2.1 MB)
• 3. How To Call A Sub Procedure.srt (5.1 KB)
• 4. Creating A Function Procedure.mp4 (1.7 MB)
• 4. Creating A Function Procedure.srt (5.3 KB)
• 5. How To Call A Function.mp4 (2.2 MB)
• 5. How To Call A Function.srt (4.9 KB)

• 1. Using Comments Within Your VBA Code.mp4 (2.4 MB)
• 1. Using Comments Within Your VBA Code.srt (7.7 KB)
• 2. Declaring Variables And Data Types.mp4 (3.8 MB)
• 2. Declaring Variables And Data Types.srt (9.9 KB)
• 3. The Scope Of A Variable.mp4 (3.1 MB)
• 3. The Scope Of A Variable.srt (7.8 KB)
• 4. The Static Declaration And Variable Expiry.mp4 (3.3 MB)
• 4. The Static Declaration And Variable Expiry.srt (9.5 KB)
• 5. Constants Instead Of Variables.mp4 (2.2 MB)
• 5. Constants Instead Of Variables.srt (6.1 KB)
• 6. An Intrinsic Constant.mp4 (2.1 MB)
• 6. An Intrinsic Constant.srt (5.3 KB)
• 7. String And Date Types Expanded.mp4 (3.6 MB)
• 7. String And Date Types Expanded.srt (9.7 KB)
• 8. Excel VBA Operators.mp4 (5.3 MB)
• 8. Excel VBA Operators.srt (13.4 KB)
• 9. Arrays.mp4 (3.0 MB)
• 9. Arrays.srt (8.4 KB)
• 10. Multi-Dimensional Arrays.mp4 (2.0 MB)
• 10. Multi-Dimensional Arrays.srt (5.6 KB)
• 11. Dynamic Arrays.mp4 (1.9 MB)
• 11. Dynamic Arrays.srt (6.7 KB)

• 1. Referencing Cells Using The Range Object.mp4 (3.0 MB)
• 1. Referencing Cells Using The Range Object.srt (8.4 KB)
• 2. The CELLS Property.mp4 (1.8 MB)
• 2. The CELLS Property.srt (4.7 KB)
• 3. The OFFSET Property.mp4 (1.5 MB)
• 3. The OFFSET Property.srt (4.3 KB)
• 4. The VALUE Of Ranges.mp4 (4.9 MB)
• 4. The VALUE Of Ranges.srt (12.4 KB)
• 5. The TEXT Object Of The RANGE.mp4 (1.9 MB)
• 5. The TEXT Object Of The RANGE.srt (4.8 KB)
• 6. A Number Of Read Only RANGE Properties.mp4 (5.5 MB)
• 6. A Number Of Read Only RANGE Properties.srt (14.0 KB)
• 7. The FONT Property And Colors.mp4 (5.2 MB)
• 7. The FONT Property And Colors.srt (13.6 KB)
• 8. Formatting Numeric Values.mp4 (2.4 MB)
• 8. Formatting Numeric Values.srt (4.9 KB)
• 9. Add Formulas To Cells Through VBA Code.mp4 (4.1 MB)
• 9. Add Formulas To Cells Through VBA Code.srt (9.6 KB)
• 10. Common METHODS Of The RANGE Object.mp4 (7.7 MB)
• 10. Common METHODS Of The RANGE Object.srt (18.2 KB)

• 1. What Is A Function.mp4 (1.1 MB)
• 1. What Is A Function.srt (2.6 KB)
• 2. Built In VBA Date Functions.mp4 (1.6 MB)
• 2. Built In VBA Date Functions.srt (4.2 KB)
• 3. Text Manipulation With VBA Functions.mp4 (2.6 MB)
• 3. Text Manipulation With VBA Functions.srt (6.2 KB)
• 4. Determining File Sizes Using FILELEN.mp4 (1.7 MB)
• 4. Determining File Sizes Using FILELEN.srt (3.6 KB)
• 5. Using Worksheet Excel Functions In VBA Code.mp4 (5.4 MB)
• 5. Using Worksheet Excel Functions In VBA Code.srt (13.4 KB)
• 6. User Defined Functions In Excel.mp4 (3.0 MB)
• 6. User Defined Functions In Excel.srt (7.0 KB)

• 1. Using GOTO And Labels.mp4 (2.6 MB)
• 1. Using GOTO And Labels.srt (7.0 KB)
• 2. Controlling The Program Flow With IF THEN ELSE.mp4 (2.5 MB)
• 2. Controlling The Program Flow With IF THEN ELSE.srt (7.2 KB)
• 3. Multiple Criteria Plus Nested IFs.mp4 (3.6 MB)
• 3. Multiple Criteria Plus Nested IFs.srt (9.2 KB)
• 4. Adding ELSEIF To Speed Up Execution.mp4 (2.6 MB)
• 4. Adding ELSEIF To Speed Up Execution.srt (7.1 KB)
• 5. SELECT CASE As An Alternative To IF.mp4 (2.9 MB)
• 5. SELECT CASE As An Alternative To IF.srt (7.1 KB)
• 6. The FOR NEXT Loop.mp4 (5.7 MB)
• 6. The FOR NEXT Loop.srt (16.1 KB)
• 7. FOR NEXT With A VBA Collection.mp4 (4.2 MB)
• 7. FOR NEXT With A VBA Collection.srt (9.8 KB)
• 8. DO WHILE Loop.mp4 (4.2 MB)
• 8. DO WHILE Loop.srt (10.5 KB)

• 1. How To Create An Event.mp4 (4.5 MB)
• 1. How To Create An Event.srt (11.6 KB)
• 2. WorkBook Events - Open.mp4 (6.3 MB)
• 2. WorkBook Events - Open.srt (12.5 KB)
• 3. Workbook Events - Closing And Saving.mp4 (5.6 MB)
• 3. Workbook Events - Closing And Saving.srt (10.5 KB)
• 4. Workbook Triggers - Activate And Deactivate.mp4 (3.8 MB)
• 4. Workbook Triggers - Activate And Deactivate.srt (7.7 KB)
• 5. Worksheet Triggers - Activate And Deactivate.mp4 (2.8 MB)
• 5. Worksheet Triggers - Activate And Deactivate.srt (5.7 KB)
• 6. Other Useful Worksheet Triggers.mp4 (6.5 MB)
• 6. Other Useful Worksheet Triggers.srt (15.4 KB)
• 7. Using Application Events.mp4 (9.0 MB)
• 7. Using Application Events.srt (19.3 KB)

• 1. Using MSGBOX To Interact With Users.mp4 (6.1 MB)
• 1. Using MSGBOX To Interact With Users.srt (13.9 KB)
• 2. Use INPUTBOX For Accepting Values From Users.mp4 (4.7 MB)
• 2. Use INPUTBOX For Accepting Values From Users.srt (11.8 KB)
• 3. Selecting A Range With The INPUT Box.mp4 (2.4 MB)
• 3. Selecting A Range With The INPUT Box.srt (6.2 KB)
• 4. An Introduction To UserForms.mp4 (3.0 MB)
• 4. An Introduction To UserForms.srt (7.0 KB)
• 5. Creating A UserForm.mp4 (3.4 MB)
• 5. Creating A UserForm.srt (7.0 KB)
• 6. Using Command Buttons In Excel.mp4 (3.8 MB)
• 6. Using Command Buttons In Excel.srt (8.6 KB)
• 7. Adding Option Buttons In A Frame.mp4 (4.0 MB)
• 7. Adding Option Buttons In A Frame.srt (7.4 KB)
• 8. Adding The Code That Makes The Form Work.mp4 (5.3 MB)
• 8. Adding The Code That Makes The Form Work.srt (11.0 KB)
• 9. Calling Your UserForm And Validating Content.mp4 (6.1 MB)
• 9. Calling Your UserForm And Validating Content.srt (12.7 KB)
• 10. UserForm Controls - The CheckBox.mp4 (6.2 MB)
• 10. UserForm Controls - The CheckBox.srt (12.7 KB)
• 11. UserForm Controls - ListBox AndOr Combo Box.mp4 (8.0 MB)
• 11. UserForm Controls - ListBox AndOr Combo Box.srt (14.6 KB)
• 12. Images On UserForms.mp4 (4.4 MB)
• 12. Images On UserForms.srt (9.2 KB)
• 13. Labels And Text Boxes.mp4 (4.1 MB)
• 13. Labels And Text Boxes.srt (8.7 KB)
• 14. Multiple Tabs On A UserForm.mp4 (6.4 MB)
• 14. Multiple Tabs On A UserForm.srt (12.2 KB)
• 15. Allowing The User To Highlight A Range.mp4 (3.2 MB)
• 15. Allowing The User To Highlight A Range.srt (6.3 KB)
• 16. Scrollbar And Spin Controls.mp4 (6.0 MB)
• 16. Scrollbar And Spin Controls.srt (13.1 KB)
• 17. Controlling Tab Order And Aligning Controls.mp4 (8.2 MB)
• 17. Controlling Tab Order And Aligning Controls.srt (14.7 KB)

• 1. Trigger A Procedure From The Quick Access Toolbar.mp4 (4.1 MB)
• 1. Trigger A Procedure From The Quick Access Toolbar.srt (8.2 KB)
• 2. Customizing The Ribbons.mp4 (4.6 MB)
• 2. Customizing The Ribbons.srt (8.2 KB)
• 3. Adding Buttons To Sheets.mp4 (2.9 MB)
• 3. Adding Buttons To Sheets.srt (5.8 KB)
• 4. Adding A Keyboard Shortcut Trigger.mp4 (2.0 MB)
• 4. Adding A Keyboard Shortcut Trigger.srt (4.7 KB)
• 5. Where To Store Your VBA Code.mp4 (5.5 MB)
• 5. Where To Store Your VBA Code.srt (12.8 KB)
• 6. Adding Code To The PERSONAL File.mp4 (6.0 MB)
• 6. Adding Code To The PERSONAL File.srt (12.8 KB)

• 1. So What's Next.mp4 (1.3 MB)
• 1. So What's Next.srt (4.2 KB)