| 1. Error Trapping the Easy Way-en_US.srt | 11.1 KB | ||
| 1. Error Trapping the Easy Way.mp4 | 9.2 MB | ||
| 1. How To Create An Event-en_US.srt | 10.2 KB | ||
| 1. How To Create An Event.mp4 | 9.2 MB | ||
| 1. Recording And Running A Simple Macro-en_US.srt | 6.1 KB | ||
| 1. Recording And Running A Simple Macro.mp4 | 5 MB | ||
| 1. Referencing Cells Using The Range Object-en_US.srt | 7.5 KB | ||
| 1. Referencing Cells Using The Range Object.mp4 | 5.8 MB | ||
| 1. So What's Next-en_US.srt | 3.7 KB | ||
| 1. So What's Next.mp4 | 1.9 MB | ||
| 1. Trigger A Procedure From The Quick Access Toolbar-en_US.srt | 7.2 KB | ||
| 1. Trigger A Procedure From The Quick Access Toolbar.mp4 | 7.5 MB | ||
| 1. Using Comments Within Your VBA Code-en_US.srt | 6.8 KB | ||
| 1. Using Comments Within Your VBA Code.mp4 | 4.4 MB | ||
| 1. Using GOTO And Labels-en_US.srt | 6.2 KB | ||
| 1. Using GOTO And Labels.mp4 | 5.1 MB | ||
| 1. Using MSGBOX To Interact With Users-en_US.srt | 12.1 KB | ||
| 1. Using MSGBOX To Interact With Users.mp4 | 12.9 MB | ||
| 1. What Is A Function-en_US.srt | 2.3 KB | ||
| 1. What Is A Function.mp4 | 1.7 MB | ||
| 1. What Is A Module-en_US.srt | 5.8 KB | ||
| 1. What Is A Module.mp4 | 4 MB | ||
| 1. What Will I Get Out Of This Course-en_US.srt | 6.9 KB | ||
| 1. What Will I Get Out Of This Course.mp4 | 3.1 MB | ||
| 10. Common METHODS Of The RANGE Object-en_US.srt | 15.9 KB | ||
| 10. Common METHODS Of The RANGE Object.mp4 | 16.1 MB | ||
| 10. Multi-Dimensional Arrays-en_US.srt | 4.9 KB | ||
| 10. Multi-Dimensional Arrays.mp4 | 3.6 MB | ||
| 10. UserForm Controls - The CheckBox-en_US.srt | 11.1 KB | ||
| 10. UserForm Controls - The CheckBox.mp4 | 13.2 MB | ||
| 11. Dynamic Arrays-en_US.srt | 5.9 KB | ||
| 11. Dynamic Arrays.mp4 | 3.5 MB | ||
| 11. UserForm Controls - ListBox AndOr Combo Box-en_US.srt | 12.8 KB | ||
| 11. UserForm Controls - ListBox AndOr Combo Box.mp4 | 16.8 MB | ||
| 12. Images On UserForms-en_US.srt | 8.1 KB | ||
| 12. Images On UserForms.mp4 | 9.4 MB | ||
| 13. Labels And Text Boxes-en_US.srt | 7.6 KB | ||
| 13. Labels And Text Boxes.mp4 | 8.9 MB | ||
| 14. Multiple Tabs On A UserForm-en_US.srt | 10.7 KB | ||
| 14. Multiple Tabs On A UserForm.mp4 | 14.1 MB | ||
| 15. Allowing The User To Highlight A Range-en_US.srt | 5.5 KB | ||
| 15. Allowing The User To Highlight A Range.mp4 | 6.6 MB | ||
| 16. Scrollbar And Spin Controls-en_US.srt | 11.5 KB | ||
| 16. Scrollbar And Spin Controls.mp4 | 12.3 MB | ||
| 17. Controlling Tab Order And Aligning Controls-en_US.srt | 12.9 KB | ||
| 17. Controlling Tab Order And Aligning Controls.mp4 | 17.4 MB | ||
| 2. Built In VBA Date Functions-en_US.srt | 3.7 KB | ||
| 2. Built In VBA Date Functions.mp4 | 3.2 MB | ||
| 2. Controlling The Program Flow With IF THEN ELSE-en_US.srt | 6.3 KB | ||
| 2. Controlling The Program Flow With IF THEN ELSE.mp4 | 5.1 MB | ||
| 2. Creating A Sub Procedure Manually-en_US.srt | 5.3 KB | ||
| 2. Creating A Sub Procedure Manually.mp4 | 3.4 MB | ||
| 2. Customizing The Ribbons-en_US.srt | 7.2 KB | ||
| 2. Customizing The Ribbons.mp4 | 8.8 MB | ||
| 2. Declaring Variables And Data Types-en_US.srt | 8.7 KB | ||
| 2. Declaring Variables And Data Types.mp4 | 7.8 MB | ||
| 2. Editing An Existing Macro In The Visual Basic Editor-en_US.srt | 6.4 KB | ||
| 2. Editing An Existing Macro In The Visual Basic Editor.mp4 | 6.5 MB | ||
| 2. Make The VBA Ignore Errors-en_US.srt | 6 KB | ||
| 2. Make The VBA Ignore Errors.mp4 | 5.5 MB | ||
| 2. The CELLS Property-en_US.srt | 4.2 KB | ||
| 2. The CELLS Property.mp4 | 3.5 MB | ||
| 2. The Excel Working Files Explained-en_US.srt | 5.5 KB | ||
| 2. The Excel Working Files Explained.mp4 | 4 MB | ||
| 2. Use INPUTBOX For Accepting Values From Users-en_US.srt | 10.3 KB | ||
| 2. Use INPUTBOX For Accepting Values From Users.mp4 | 9.5 MB | ||
| 2. WorkBook Events - Open-en_US.srt | 10.9 KB | ||
| 2. WorkBook Events - Open.mp4 | 13 MB | ||
| 3. Adding Buttons To Sheets-en_US.srt | 5.1 KB | ||
| 3. Adding Buttons To Sheets.mp4 | 5.1 MB | ||
| 3. How To Call A Sub Procedure-en_US.srt | 4.5 KB | ||
| 3. How To Call A Sub Procedure.mp4 | 3.8 MB | ||
| 3. Interact With The User When An Error Occurs-en_US.srt | 7.5 KB | ||
| 3. Interact With The User When An Error Occurs.mp4 | 6.6 MB | ||
| 3. Multiple Criteria Plus Nested IFs-en_US.srt | 8.1 KB | ||
| 3. Multiple Criteria Plus Nested IFs.mp4 | 7.2 MB | ||
| 3. Selecting A Range With The INPUT Box-en_US.srt | 5.5 KB | ||
| 3. Selecting A Range With The INPUT Box.mp4 | 4.7 MB | ||
| 3. Text Manipulation With VBA Functions-en_US.srt | 5.5 KB | ||
| 3. Text Manipulation With VBA Functions.mp4 | 5.4 MB | ||
| 3. The New Macro Enabled File Type-en_US.srt | 3.6 KB | ||
| 3. The New Macro Enabled File Type.mp4 | 3.6 MB | ||
| 3. The OFFSET Property-en_US.srt | 3.8 KB | ||
| 3. The OFFSET Property.mp4 | 3.1 MB | ||
| 3. The Scope Of A Variable-en_US.srt | 6.9 KB | ||
| 3. The Scope Of A Variable.mp4 | 6.1 MB | ||
| 3. What Is VBA For Excel-en_US.srt | 9.4 KB | ||
| 3. What Is VBA For Excel.mp4 | 3.5 MB | ||
| 3. Workbook Events - Closing And Saving-en_US.srt | 9.2 KB | ||
| 3. Workbook Events - Closing And Saving.mp4 | 11.9 MB | ||
| 4. Adding A Keyboard Shortcut Trigger-en_US.srt | 4.1 KB | ||
| 4. Adding A Keyboard Shortcut Trigger.mp4 | 3.4 MB | ||
| 4. Adding ELSEIF To Speed Up Execution-en_US.srt | 6.3 KB | ||
| 4. Adding ELSEIF To Speed Up Execution.mp4 | 5.3 MB | ||
| 4. An Introduction To UserForms-en_US.srt | 6.2 KB | ||
| 4. An Introduction To UserForms.mp4 | 6.1 MB | ||
| 4. Creating A Function Procedure-en_US.srt | 4.7 KB | ||
| 4. Creating A Function Procedure.mp4 | 3 MB | ||
| 4. Determining File Sizes Using FILELEN-en_US.srt | 3.2 KB | ||
| 4. Determining File Sizes Using FILELEN.mp4 | 3.6 MB | ||
| 4. Excel 2010 Security Settings And Macro Files-en_US.srt | 6 KB | ||
| 4. Excel 2010 Security Settings And Macro Files.mp4 | 5.4 MB | ||
| 4. Making Use Of The ERR Object-en_US.srt | 5.5 KB | ||
| 4. Making Use Of The ERR Object.mp4 | 6.3 MB | ||
| 4. Quick Tour Of The Excel Visual Basic Editor-en_US.srt | 9.9 KB | ||
| 4. Quick Tour Of The Excel Visual Basic Editor.mp4 | 7.4 MB | ||
| 4. The Static Declaration And Variable Expiry-en_US.srt | 8.3 KB | ||
| 4. The Static Declaration And Variable Expiry.mp4 | 6.3 MB | ||
| 4. The VALUE Of Ranges-en_US.srt | 10.9 KB | ||
| 4. The VALUE Of Ranges.mp4 | 9.9 MB | ||
| 4. Workbook Triggers - Activate And Deactivate-en_US.srt | 6.7 KB | ||
| 4. Workbook Triggers - Activate And Deactivate.mp4 | 7.9 MB | ||
| 5. Constants Instead Of Variables-en_US.srt | 5.4 KB | ||
| 5. Constants Instead Of Variables.mp4 | 4.1 MB | ||
| 5. Creating A UserForm-en_US.srt | 6.2 KB | ||
| 5. Creating A UserForm.mp4 | 7.6 MB | ||
| 5. Debugging Techniques-en_US.srt | 8.4 KB | ||
| 5. Debugging Techniques.mp4 | 8.3 MB | ||
| 5. How To Call A Function-en_US.srt | 4.3 KB | ||
| 5. How To Call A Function.mp4 | 4.1 MB | ||
| 5. SELECT CASE As An Alternative To IF-en_US.srt | 6.2 KB | ||
| 5. SELECT CASE As An Alternative To IF.mp4 | 6 MB | ||
| 5. The Developer Ribbon-en_US.srt | 2.9 KB | ||
| 5. The Developer Ribbon.mp4 | 3.4 MB | ||
| 5. The TEXT Object Of The RANGE-en_US.srt | 4.2 KB | ||
| 5. The TEXT Object Of The RANGE.mp4 | 3.9 MB | ||
| 5. Using Worksheet Excel Functions In VBA Code-en_US.srt | 11.7 KB | ||
| 5. Using Worksheet Excel Functions In VBA Code.mp4 | 10.8 MB | ||
| 5. Watch A Macro Write Your VBA-en_US.srt | 4.7 KB | ||
| 5. Watch A Macro Write Your VBA.mp4 | 5.2 MB | ||
| 5. Where To Store Your VBA Code-en_US.srt | 11.3 KB | ||
| 5. Where To Store Your VBA Code.mp4 | 10.3 MB | ||
| 5. Worksheet Triggers - Activate And Deactivate-en_US.srt | 5 KB | ||
| 5. Worksheet Triggers - Activate And Deactivate.mp4 | 5.7 MB | ||
| 6. A Number Of Read Only RANGE Properties-en_US.srt | 12.3 KB | ||
| 6. A Number Of Read Only RANGE Properties.mp4 | 11.6 MB | ||
| 6. Adding Code To The PERSONAL File-en_US.srt | 11.2 KB | ||
| 6. Adding Code To The PERSONAL File.mp4 | 12.6 MB | ||
| 6. An Intrinsic Constant-en_US.srt | 4.7 KB | ||
| 6. An Intrinsic Constant.mp4 | 4.3 MB | ||
| 6. Other Useful Worksheet Triggers-en_US.srt | 13.4 KB | ||
| 6. Other Useful Worksheet Triggers.mp4 | 12.9 MB | ||
| 6. The FOR NEXT Loop-en_US.srt | 14.1 KB | ||
| 6. The FOR NEXT Loop.mp4 | 11.6 MB | ||
| 6. User Defined Functions In Excel-en_US.srt | 6.1 KB | ||
| 6. User Defined Functions In Excel.mp4 | 5.7 MB | ||
| 6. Using Breakpoints To Help Debug-en_US.srt | 8.2 KB | ||
| 6. Using Breakpoints To Help Debug.mp4 | 8.4 MB | ||
| 6. Using Command Buttons In Excel-en_US.srt | 7.5 KB | ||
| 6. Using Command Buttons In Excel.mp4 | 8.5 MB | ||
| 7. Adding Option Buttons In A Frame-en_US.srt | 6.5 KB | ||
| 7. Adding Option Buttons In A Frame.mp4 | 8.9 MB | ||
| 7. FOR NEXT With A VBA Collection-en_US.srt | 8.6 KB | ||
| 7. FOR NEXT With A VBA Collection.mp4 | 8.5 MB | ||
| 7. Setup And Use A Watch-en_US.srt | 7.2 KB | ||
| 7. Setup And Use A Watch.mp4 | 7.6 MB | ||
| 7. String And Date Types Expanded-en_US.srt | 8.6 KB | ||
| 7. String And Date Types Expanded.mp4 | 7 MB | ||
| 7. The FONT Property And Colors-en_US.srt | 11.9 KB | ||
| 7. The FONT Property And Colors.mp4 | 10.4 MB | ||
| 7. Using Application Events-en_US.srt | 16.8 KB | ||
| 7. Using Application Events.mp4 | 18.1 MB | ||
| 8. Adding The Code That Makes The Form Work-en_US.srt | 9.7 KB | ||
| 8. Adding The Code That Makes The Form Work.mp4 | 12.4 MB | ||
| 8. DO WHILE Loop-en_US.srt | 9.3 KB | ||
| 8. DO WHILE Loop.mp4 | 7.8 MB | ||
| 8. Excel VBA Operators-en_US.srt | 11.7 KB | ||
| 8. Excel VBA Operators.mp4 | 10.6 MB | ||
| 8. Formatting Numeric Values-en_US.srt | 4.3 KB | ||
| 8. Formatting Numeric Values.mp4 | 4.7 MB | ||
| 8. Speeding Up The VBA Tips-en_US.srt | 17.6 KB | ||
| 8. Speeding Up The VBA Tips.mp4 | 20.8 MB | ||
| 9. Add Formulas To Cells Through VBA Code-en_US.srt | 8.4 KB | ||
| 9. Add Formulas To Cells Through VBA Code.mp4 | 8.4 MB | ||
| 9. Arrays-en_US.srt | 7.5 KB | ||
| 9. Arrays.mp4 | 5.5 MB | ||
| 9. Calling Your UserForm And Validating Content-en_US.srt | 11.1 KB | ||
| 9. Calling Your UserForm And Validating Content.mp4 | 12.6 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Working Files - Download These First.html | 0 B | ||
| ▲ 182 total files | |||
Visual Basic for Excel - Microsoft VBA Excel Tutorial
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 676 MB | Duration: 8h 6m
Description
A Verifiable Certificate of Completion is presented to all students who undertake this course.
In this Visual Basic for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.
The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This Visual Basic for Excel tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.
By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn Visual Basic for Microsoft Excel in this video tutorial.
SCREENSHOTS
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 943.6 MB | freecoursewb | 2 months | 0 | 0 | |
|
Skillshare - Visual Basic . Net - with Real World Database Application - for Beginners Posted by
freecoursewb in Other
|
3.2 GB | freecoursewb | 4 years | 0 | 0 |
|
Udemy - Apprendre Visual Basic et WinForm pour créer des logiciels 2021 MP4 [Français] Posted by
MaroueneCh in Other
|
2.41 GB | MaroueneCh | 4 years | 7 | 0 |
| 676.56 MB | tutsnode | 5 years | 0 | 0 | |
|
Udemy - VB.NET Masterclass: Learn Visual Basic and VBScript [Course Drive] Posted by
coursedrive in Other
|
1.8 GB | coursedrive | 6 years | 2 | 1 |
All Comments