in the top left of the Excel window and then click on the Excel Options button. When the Excel Options window appears, click on the Popular option on the left. Select the option called “Show Developer tab in the Ribbon”.

You can access the VBA environment in Excel 2007 by opening the Microsoft Visual Basic window. First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.

To enable or disable access to Visual Basic projects with the 2007 Microsoft Office system

1. On the Tools menu in Word or Excel, point to Macro, and then click Security.
2. In the Security dialog box, click the Trusted Publishers tab.
3. Select to enable, or clear to disable, Trust Access to Visual Basic Project.
4. Click OK.

At a basic level, you can create a UserForm in the following 6 simple steps:

1. Insert a UserForm.
2. Add controls to the UserForm.
3. Move or resize the added UserForm controls, as required.
4. Customize the UserForm or its controls.
5. Assign VBA code to the UserForm.
6. Display or load the UserForm.
7. Close or hide the UserForm.

Userform

1. Open the Visual Basic Editor. If the Project Explorer is not visible, click View, Project Explorer.
2. Click Insert, Userform. If the Toolbox does not appear automatically, click View, Toolbox.
3. Add the controls listed in the table below.
4. Change the names and captions of the controls according to the table below.

To edit a macro that is attached to a Microsoft Excel workbook, you use the Visual Basic Editor….Edit the macro

1. On the Developer tab, in the Code group, click Macros.
2. In the Macro name box, click the macro that you want to edit.
3. Click Edit. The Visual Basic Editor appears.

Enable or disable Edit mode

1. Click File > Options > Advanced. -OR- In Excel 2007 only: Click the Microsoft Office Button.
2. Under Editing options, do one of the following: To enable Edit mode, select the Allow editing directly in cells check box. To disable Edit mode, clear the Allow editing directly in cells check box.

Excel 2007: Show the Developer tab or run in developer mode

1. Click the Microsoft Office Button Button image, and then click Excel Options.
2. Click Popular, and then select the Show Developer tab in the Ribbon check box.

Here are the steps:

1. Go to File –> Options.
2. In the Excel Options dialogue box, click on Customize Ribbon in the left pane. It will show the Customize the Ribbon options on the right.
3. On the right, within the Main Tabs pane, check the Developer option.
4. Click OK.

Show the Developer tab. On the Excel menu,click Preferences.

VBA – User Forms. A User Form is a custom-built dialog box that makes a user data entry more controllable and easier to use for the user. In this chapter, you will learn to design a simple form and add data into excel. Step 1 − Navigate to VBA Window by pressing Alt+F11 and Navigate to “Insert” Menu and select “User Form”.

To open the VBA window, press the Alt + F11 buttons in your keyboard. The Open Form function is to open specific form when an action is occurred, such as when clicking button in a form.

VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now predominantly used with Microsoft Office applications such as MSExcel, MS-Word and MS-Access. This tutorial teaches the basics of VBA. Each of the sections contain related topics with simple and useful examples.