CATEGORY: Excel General VERSIONS: All Microsoft Excel Versions

Step 1: Defining two Names to be used in a Combo Box: 1. Add a list of months to a new sheet, select cell A2, and then press Ctrl+Shift+Down Arrow to select the list. 2. Press Ctrl+F3 and define the Name MonthsList. 3. Select cell B2, press Ctrl+F3 and define the Name MonthSelectionNumber. Step 2: Adding a Combo Box: 1. In the sheet where the report is being created, place the mouse arrow over any toolbar, right click, and then select Forms from the shortcut menu. 2. Click the Combo Box icon. The cursor changes into a cross. 3. Select a cell in the sheet, and draw the shape of the Combo Box. When you are finished, a Combo Box appears. 4. Select the Combo Box you just created and make sure you are in edit mode (see the small circles in the screenshot below). 5. Right-click, and select Format Control from the shortcut menu. 6. Select the Control tab. 7. In the Input Range box, type the previously defined Name, MonthsList. 8. In the Cell Link box, type the defined Name, MonthSelectionNumber. 9. Select the 3-D shading checkbox, and click OK.

Screenshot // Adding a Combo Box

Rate this tip 1 2 3 4 5   RATING: 3.11   VIEWS: 54936 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

Merging bijan1231 wrote on December 31, 1969 19:00 EST Merge different sheets in one sheet having the same column name

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

The Analysis and Use of Financial Statements The Basics of Finance: Financial Tools for Non Financial Managers Marketing Planning for Services Marketing Plans That Work, Targeting Growth and Profitability Financial Reporting and Analysis (2nd Edition) The Accounting Game : Basic Accounting Fresh from the Lemonade Stand

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books