Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include; proper variable declaration, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: Macro Development Basics|
Displaying the Developer Tab
Setting Macro Trust within Excel 2010
Recording and Running a Macro
Examining the VBA Editor
|Section 3: VBA Programming Fundamentals|
Reviewing the Excel 2010 Object Model
Understanding Functions and Procedures
Understanding Variables and Scope
Commenting Your Code
|Section 4: Working with Control Structures|
Understanding Logical Operators
Creating a Select/Case Statement
Creating For/Next Loops
Creating Do Loops
Creating While/Wend Loops
|Section 5: Using VBA Functions|
Viewing the Object Browser
Using the InputBox() Function
Understanding the MsgBox() Function
Using String Functions
Using Date Functions
|Section 6: Creating UserForms|
Designing a FormPreview
Understanding Different ControlsPreview
Working with Form Properties
|Section 7: Debugging Techniques|
Understand the Difference Between Syntax and Logic Errors
Stepping Through Your Macro
Adding Error Traps
|Section 8: Conclusion|
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.