Excel 2007 VBA
4.4 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a 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.
178 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2007 VBA to your Wishlist.

Add to Wishlist

Excel 2007 VBA

Power up your workbooks with Visual Basic for Applications automation
4.4 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a 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.
178 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the object model
  • Create, edit and run recorded macros
  • Understand the Visual Basic editor
  • Understand programming basics
  • Use Visual Basic functions
  • Create and use cotnrol structures
  • Create, use and edit UserForms
  • Debug macros and trap for errors
View Curriculum
Requirements
  • Intermediate Microsoft Excel training or equivalent experience
Description

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.

Who is the target audience?
  • Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks
Students Who Viewed This Course Also Viewed
Curriculum For This Course
47 Lectures
04:14:02
+
Introduction
1 Lecture 02:43
+
Understanding the Excel Object Model
2 Lectures 04:57
+
Creating Recorded Macros
5 Lectures 14:31


Recording a Macro
06:40

Running a Macro
00:40

Editing a Macro with the Visual Basic Editor
03:03
+
Understanding the Visual Basic Editor
7 Lectures 32:21
Examining the VBA Editor Menu and Toolbar
09:43

Setting VBA Editor Options
08:52

Reviewing the Project Explorer
01:14

Reviewing the Properties Window
03:04

Understanding the Object and Procedure drop-down lists
01:16

Viewing the Immediate Window
02:36

Viewing the Object Browser
05:36
+
Understanding Programming Basics
8 Lectures 54:50

Dimensioning Variable
12:27

Understanding Object Variables
05:10

Understanding Variables and Scope
05:44

Commenting your Code
04:53

Creating Constants
04:28

Manipulating Data
06:33

Understanding Procedure Arguments
09:42
+
Using Visual Basic Functions
4 Lectures 44:39
Using the InputBox() Function
11:22

Understanding the MsgBox() Function
10:02

Using String Functions
12:07

Using Date Functions
11:08
+
Working with Control Structures
6 Lectures 34:31
Using If/Then/Else
06:41

Creating a Select/Case Statement
05:02

Understanding Logical Operators
04:30

Creating For/Next Loops
06:58

Creating Do Loops
06:20

Creating While/Wend Loops
05:00
+
Creating UserForms
7 Lectures 33:01

Understanding Controls
11:28

Setting Control Properties
01:06

Referencing Controls in VBA Code
02:44

Responding to Events
11:16

Creating a function to open a UserForm
02:19

Development Tips
02:59
+
Debugging your Macros
6 Lectures 29:04

Running your Macro from the VBA Editor
01:01

Setting Breakpoints
01:35

Stepping Through Your Macro
03:44

Creating Watches
06:58

Adding Error Trapping
11:24
+
Conclusion
1 Lecture 03:25
Conclusion
03:25
About the Instructor
Intellezy Trainers
4.4 Average rating
4,099 Reviews
25,131 Students
136 Courses
Computer Training Specialists

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.