• LOGIN
  • No products in the basket.

Login

Learning Objectives

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

 

Pre-Requisites

Intermediate Microsoft Excel training or equivalent experience is recommended.

 

Description

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.

Course Curriculum

Course Introduction
Introduction 00:03:00
Section 01
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
Section 02
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
Section 03
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
Section 04
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
Section 05
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
Section 06
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
Section 07
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
Section 08
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
Course Recap
Recap 00:02:00
Additional Materials
Resource – Excel 365 VBA Expert 00:00:00

FAQs

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.

© iStudy
Select your currency
GBP Pound sterling