Excel VBA 2010 - Expert
Automate Excel 2010 with VBA in these self-paced lessons: record macros, explore the object model, write procedures with variables and control structures, build UserForms and debug your code with breakpoints.
About this course
Automate Excel 2010 with VBA in these self-paced lessons: record macros, explore the object model, write procedures with variables and control structures, build UserForms and debug your code with breakpoints.
Curriculum
- Introduction
- Displaying the Developer Tab
- Setting Macro Trust within Excel 2010
- Recording and Running a Macro
- Examining the VBA Editor
- Reviewing the Excel 2010 Object Model
- Understanding Functions and Procedures
- Understanding Variables and Scope
- Commenting Your Code
- Creating Constants
- Understanding Arguments
- Using If-Then-Else
- Understanding Logical Operators
- Creating a Select-Case Statement
- Creating For-Next Loops
- Creating Do Loops
- Creating While-Wend Loops
- Viewing the Object Browser
- Using the InputBox Function
- Understanding the MsgBox Function
- Using String Functions
- Using Date Functions
- Designing a Form
- Understanding Different Controls
- Working with Form Properties
- Understand the Difference Between Syntax and Logic Errors
- Using Breakpoints
- Stepping Through Your Macro
- Creating Watches
- Adding Error Traps
- Course Recap
Who it's for
Experienced Excel 2010 users ready to automate repetitive tasks with code.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.