Excel Vba Tutorial Install The Visual

Congratulations, you are now ready to work in the Visual Basic Editor.

Example use cases for this are accounting, basic math, calculating discounts when purchasing web hosting, websites more.

VBA procedures developed in the VBE become part of the workbook in which they are developed and when the workbook is saved the VBA components (including macros, modules, userforms and other components that you will discover in the next 32 lessons) are saved.

Excel Vba Tutorial Install The Visual

If you are using Excel 2007 see how to install the Visual Basic Editor for Excel from your Office CD.

At any time if you feel uncomfortable, just close Excel without saving the workbook and try again later.

From the menu bar of Excel select Tools then Macro then Security and select Medium.

Check the second level Disable all Macros with Notification and you are set.

We will open it and start by setting it up so that working within it becomes easy and efficient.

You can resize the windows by left-clicking where the red stars are, holding and moving sideways or up and down.

We will study each of the three windows in lessons 2, 3 and 4 but first we will set them.

If the project window appears in the middle of the gray area like above, right-click in the white space in the middle of the project window and check Dockable.

Then click on the top blue bar of the Project window, hold and drag it left until the cursor (white arrow) touches the middle of the left side of the screen.

When you let go of the mouse button the end result should be like shown in the image below.

Congratulations you have setup the first major window of the VBE.

When it turns to two small parallel lines and arrows click, hold and move the lines sideways.

The Properties window will appear somewhat like in the image below.

If it shows like in the image above, right-click in the white space in the middle of the Properties window and check Dockable.

Then click on the top blue bar of the Properties window and drag it left and down until the cursor (white arrow) touches the center of the bottom of the Project window.

Congratulations you have setup the second major window of the VBE.

When it turns to two small parallel lines and arrows click, hold and move the lines vertically.

You can maximize any Code window by clicking on its Maximize button.

The words Option Explicit might not be present in your Code window.

We will address this issue later in the lesson on variables (Lesson 19).

You might also have a VBAProject named FUNCRES.XLA or FUNCRES.XLAM in the project window.

Excel For Mac Vba Tutorial