This tab contains a variety of tools that allows development and customization of Excel macro applications. The Developer tab is not visible by default in Excel, we must configure it to show that tab. In this chapter, learn how to turn on the Developer tab.

Create a simple macro that will be executed after clicking on a command button. With Excel VBA you can automate tasks in Excel using what is called a macro.

Ensure PERSONAL is selected and click OK.This article is mainly focused on creating applications using the Visual Basic for Applications (VBA) programming language.

The personal workbook must be unhidden if you want to edit any macros saved in it. However, this file is hidden by default, so you wouldn’t know it’s there unless you unhide it. It’s saved on your computer and opens every time you open Excel. The personal workbook is a special file that stores universal macros. If it’s saved in the personal workbook, you’ll need to unhide it first. Unhide the Personal Workbookīefore you start editing a macro, you need to think about where it’s saved. In this lesson we’ll look at how to view and edit the code for an existing macro. The best way to learn about Visual Basic is to view existing code. Using the Visual Basic language and the Visual Basic editor, you can make minor changes to your macros once you have recorded them. This lesson introduces you to the Visual Basic (also called VB or VBA) programming language-the code Excel uses to record macros.

If you record a macro and later want to make changes without having to re-record it, it can be edited in the Visual Basic window.

Visual basic for excel 2010