Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion
Intermediate Microsoft Excel training or equivalent experience is recommended.
This course will teach students proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.
|Lesson 1-Adding the Developer Toolbar||00:05:00|
|Lesson 2-Understanding the VBA Editor||00:11:00|
|Lesson 3-Recording a Macro in Personal||00:10:00|
|Lesson 4-Understanding the Elements of the VBA Language||00:07:00|
|Lesson 5-Understanding Methods||00:05:00|
|Lesson 6-Understanding Comments||00:06:00|
|Lesson 7-Working with the Range Property and Worksheet Object||00:07:00|
|Lesson 8-Adding a Macro Button to a Spreadsheet||00:03:00|
|Lesson 9-Working with the ActiveCell Object||00:02:00|
|Lesson 10-Working with the Offset Property||00:08:00|
|Lesson 1-Understanding Variables||00:07:00|
|Lesson 2-Working with Integer Variables||00:03:00|
|Lesson 3-Understanding Option Explicit||00:05:00|
|Lesson 4-Working with Other Variable Types||00:07:00|
|Lesson 1-Working with IF Statements||00:04:00|
|Lesson 2-Working with ELSE||00:03:00|
|Lesson 3-Working with ELSEIF||00:03:00|
|Lesson 4-Understanding Conditional Operators||00:06:00|
|Lesson 5-Working with NOT, AND, and OR||00:07:00|
|Lesson 6-Working with Nested IF||00:04:00|
|Lesson 7-Working with Select Case||00:06:00|
|Lesson 8-Working with WITH and END WITH||00:05:00|
|Lesson 1-Working with Text Strings||00:05:00|
|Lesson 2-Working with LCASE and UCASE Functions||00:05:00|
|Lesson 3-Working with LEN and TRIM Functions||00:07:00|
|Lesson 4-Working with LEFT, RIGHT, and MID Functions||00:07:00|
|Lesson 1-Understanding Loops||00:02:00|
|Lesson 2-Working with For Next Loops||00:07:00|
|Lesson 3-Working with For Each Loops||00:06:00|
|Lesson 4-Working with Cells Property||00:08:00|
|Lesson 5-Working with Do Until Loops||00:09:00|
|Lesson 6-Working with Do While Loops||00:05:00|
|Lesson 1-Calling Sub Procedures||00:05:00|
|Lesson 2-Working with Exit Sub||00:04:00|
|Lesson 3-Working with Message Boxes||00:08:00|
|Lesson 4-Working with Input Boxes||00:08:00|
|Lesson 5-Working with VBA Functions||00:12:00|
|Lesson 6-Working with Object Variable and Set||00:06:00|
|Lesson 1-Understanding and Creating a User Form||00:08:00|
|Lesson 2-Adding Controls to a User Form||00:16:00|
|Lesson 3-Adding Code for a User Form||00:10:00|
|Lesson 4-Launching a User Form from Excel||00:05:00|
|Lesson 1-Getting Started with Debugging||00:10:00|
|Lesson 2-Stepping Through Your Code||00:06:00|
|Lesson 3-Working with Breakpoints||00:03:00|
|Lesson 4-Working with the Immediate Window||00:05:00|
|Lesson 5-Working with the Locals Window||00:05:00|
|Lesson 6-Working with the Err Object||00:06:00|
|Lesson 7-Getting Help-v2||00:07:00|
|Resource – Excel 365 VBA Expert||00:00:00|
This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.
No prior qualifications are needed to take this course.
You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!
Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.
Don’t worry if you fail the test, you can retake it as many times as you want.
You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.
We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.
After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.