Toll-Free: 844-VBA-HELP
Subscribe to Newsletter

Work with Microsoft MVPs.  Some of the best and brightest when it comes to Microsoft applications!  



Hire our team for all of your Microsoft Consulting, Programming and Training needs

Previous Next

Microsoft Excel VBA Certification Program.  The ONLY VBA Certification Program Around. Just Ten Easy Lessons. The First Lesson is Free. You are Guaranteed to Learn. We will help you. We will Answer Your Questions. The Forums will Help Too!!! Get Answers to Your Code Questions.

Excel Academy is Microsoft Excel VBA Training

Written by a top Microsoft Excel MVP


Jacob Hilderbrand, one of the ownders at VBAExpress, Inc.
Client Testimonial

"When I applied for a job. I wanted to have something tangible to show on my job resume so I decided to take the training from VBA Express driven by the confidence the site has provided me along the years; and I was not disappointed. The training content is extremely easy to read and understand. The contents are solid enough to build knowledge but at the same time easy for the beginners to grasp the concepts. I wished I had something like this when I first started studying macros; it could have saved me countless headaches and frustration.

I highly recommend the Training with the site. It will make the learning experience easier and faster. In no time after doing the training you will be writing code in no time .”
See the complete testimonial


Free Preview !!! Get Excel VBA Training Lesson 1 for Free Today !!!


 

Only $99.95


Lessons 1 to 10



Here Is How To Sign-up


Making the payment is easy with PayPal
 


Introduction: To most people Excel is nothing more than a glorified calculator, or a white board for setting up text and images. Some people view Excel as a simple word processor with built-in tables. Sadly, most Excel users will never know, let alone understand, the program’s full potential.

Delve deeper into the features of Excel and see the complex calculations that can be performed, or the variety of charts that can be created to display virtually any amount of data. But even with all these features, it may seem that Excel cannot do everything that is desired. Users may perceive these obstacles as real and simply move on, never knowing that Excel has even more tools available that allow us to manipulate and automate the program itself in many ways. Those tools come in the form of an interface to the programming environment, and allow us to run our own code to have Excel perform unimaginable tasks.

Don’t let the idea of having to write your own code put you off. Here at VBA Express we write the code and all you have to do is add it to your workbook. This particular lesson demonstrates how to navigate through the programming environment, and use code, without ever having to write a single line of it. Though I would imagine that once you have the knowledge necessary to start writing your own code, you won’t want to stop.

This lesson assumes that you are familiar with most of the features of Excel, but you don’t need to be an Excel guru to understand it.

In this lesson we introduce the programming environment of Excel. We discuss the programming language, Visual Basic for Applications (VBA). We discuss the Visual Basic Editor (VBE) and learn where the code actually needs to be placed. We discuss the settings and functions that govern the VBE. And we see how to create our own modules and how to set them up to meet our needs before we start writing any code.

Throughout this lesson there are images of icons or screen shots that show exactly what we are working with. If possible, open Excel on your computer and use it throughout the lesson. .

Lesson Objectives
  • Learn the difference between the Excel environment and the Visual Basic for Applications environment.
  • Learn the definition of some key terms used in the VBA environment.
  • Learn the components of the Visual Basic Editor window.
  • Learn the components of the Visual Basic Editor Toolbar.
  • Learn the options available for customization in the Visual Basic Environment.
  • Learn the components of the Project Explorer window, and how to navigate it.
  • Learn the components of the Properties window and how to navigate it.
  • Learn the components of the Properties window and how to navigate it.
  • Learn how to use a very simple macro.

Guarantee: If you follow the course, and put in the time, we guarantee you will learn how to code in Microsoft Visual Basic for Applications (VBA).

Click here to register for the Excel VBA Academy.