Excel 2007 VBA
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
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.
This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, 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: Understanding the Excel Object Model|
Referencing Workbooks, Worksheets, and CellsPreview
|Section 3: Creating Recorded Macros|
Displaying the Developer TabPreview
Setting Macro Trust within ExcelPreview
Recording a Macro
Running a Macro
Editing a Macro with the Visual Basic Editor
|Section 4: Understanding the Visual Basic Editor|
Examining the VBA Editor Menu and Toolbar
Setting VBA Editor Options
Reviewing the Project Explorer
Reviewing the Properties Window
Understanding the Object and Procedure drop-down lists
Viewing the Immediate Window
Viewing the Object Browser
|Section 5: Understanding Programming Basics|
Understanding Functions and ProceduresPreview
Understanding Object Variables
Understanding Variables and Scope
Commenting your Code
Understanding Procedure Arguments
|Section 6: Using Visual Basic Functions|
Using the InputBox() Function
Understanding the MsgBox() Function
Using String Functions
Using Date Functions
|Section 7: Working with Control Structures|
Creating a Select/Case Statement
Understanding Logical Operators
Creating For/Next Loops
Creating Do Loops
Creating While/Wend Loops
|Section 8: Creating UserForms|
Setting Control Properties
Referencing Controls in VBA Code
Responding to Events
Creating a function to open a UserForm
|Section 9: Debugging your Macros|
Understanding Logic Errors and Syntax ErrorsPreview
Running your Macro from the VBA Editor
Stepping Through Your Macro
Adding Error Trapping
|Section 10: 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.