We use cookies to give you the best experience when you browse our site. For more information about the cookies we use or to view our privacy policy, click here.
With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today! With thousands of short segment IT video lessons at your disposal. Get started today!

Excel VBA 2007

Expert
Request a Free Trial

Course Overview

Instructor: Timothy Miles
Subject: Excel VBA 2007
Duration: 04 Hour 14 Minutes
Level: Expert
Pre-requisites: Intermediate Microsoft Excel training or equivalent experience.

Description

This course introduces you to Excel Macro programming using Microsoft's Visual Basic for Applications (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.

Introduction
Introduction2min 43sec
Understanding the Excel Object Model Creating Recorded Macros Understanding the Visual Basic Editor Understanding Programming Basics Using Visual Basic Functions Working with Control Structures Creating UserForms Debugging Your Macros Conclusion
Course Recap3min 25sec

Timothy Miles

Tim has been a professional developer for over 20 years. He has worked with almost every industry, creating many different software solutions. If it requires code, he has probably worked with it.

Learn More About Timothy Miles