Excel 2007 VBA

Power up your workbooks with Visual Basic for Applications automation
4.3 (10 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.
136 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 47
  • Length 4 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English

Course 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.

What are the requirements?

  • Intermediate Microsoft Excel training or equivalent experience

What am I going to get from this course?

  • 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

What is the target audience?

  • Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
02:43
Section 2: Understanding the Excel Object Model
Understanding Objects
Preview
01:50
Referencing Workbooks, Worksheets, and Cells
Preview
03:07
Section 3: Creating Recorded Macros
Displaying the Developer Tab
Preview
02:10
Setting Macro Trust within Excel
Preview
01:58
Recording a Macro
06:40
Running a Macro
00:40
Editing a Macro with the Visual Basic Editor
03:03
Section 4: Understanding the Visual Basic Editor
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
Section 5: Understanding Programming Basics
Understanding Functions and Procedures
Preview
05:53
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
Section 6: Using Visual Basic Functions
Using the InputBox() Function
11:22
Understanding the MsgBox() Function
10:02
Using String Functions
12:07
Using Date Functions
11:08
Section 7: Working with Control Structures
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
Section 8: Creating UserForms
Understanding UserForms
Preview
01:09
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
Section 9: Debugging your Macros
Understanding Logic Errors and Syntax Errors
Preview
04:22
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
Section 10: Conclusion
Conclusion
03:25

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, 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.

Ready to start learning?
Take This Course