Add Combo Box to a Sheet in Microsoft Excel
Step 1: Define names
1.Enter the months list - January-December into the cells A1 to A12 in the new worksheet.
2.Select cells A!:A12, press Ctrl+F3, enter the text MonthsList into the Names In workbook box,and click OK.
3.Select Cell B1, press Ctrl+F3, enter the text MonthNumber into the Names in Workbook box, and click OK.
Step 2: Add a Combo Box to a worksheet
1. Select one of the toolbars, right-click, and select the Forms toolbar.
2. Copy the Combo Box by clicking the Combo Box icon, and then release the mouse. Create a rectangle with the mouse in the worksheet, and then release the mouse.
Step 3: Format the Combo Box
1.Select the Combo Box; right-click; and from the shortcut menu that appears, select Format Control. Then select the Control tab
2.In the Input range box, type the name MonthsList (You cannot press F3 to paste a name with an object).
3.In the Cell link box, type the name MonthNumber.
4.Click to select the 3-D shading box (more aesthetic).
Exit the formatting mode of Combo Box, and select a cell in the sheet. Open the list of items in the Combo Box, and select a month. Note that the new month number is shown in cell B1.