Tuesday, December 24, 2013

How to Create a UserForm in Excel 2007


1. Start Excel 2007 and open a new workbook. Click the Microsoft Office Button (on the upper left corner of your task bar), and select Excel Options. In the new pop-up window, click Popular, and check the box titled 'Show Developer tab in the Ribbon.' In Microsoft Office Excel 2007, click Visual Basic in the Code group on the Developer tab. You should now see the Developer Tab on the top of your screen.
2. Click Visual Basic on the Developer tab. Visual basic can be found under Code group on the Developer tab. Now go the Insert menu and select User Form. You can now customize your User Form according to the task you want it to accomplish. If necessary, draw frame controls and label controls. Labels make data entry easier by naming columns and are often needed for data-driven forms.
3. Type the macro code. Double-click the user form to bring up the code window, where you will insert the macro code.
4. Save the user form. When you are finished with the macro, save it and return to Excel. Now go to the Developer tab and click on Macros. In the new pop-up window, click on Show User Form, and press Run to activate your User Form.

Blogger news