Draw a Combo Box Control Excel
How to speedily create combo box in Excel?
As nosotros all known, combo box is a drop downwards list box which combines a text box with a listing box. In Excel，there are two types of combo box, one is Form Control combo box, some other is ActiveX Control combo box as left screenshots shown. Today, I will talk about how to create these two types of combo box in Excel.
Create Form Control combo box in Excel
Create ActiveX Control combo box and change the font size in Excel
Create Form Control combo box in Excel
To insert this Form Command combo box, you need to actuate the Programmer tab in the ribbon start. Please do with following steps:
1. In Excel 2010/2013, go to click File > Options, and and so click Customize Ribbon from the left pane, and check Programmer in the Excel Options dialog, at last click OK.
In Excel 2007, click Office push > Excel Options to open the Excel Options dialog box, in the left pane, click Popular, and in the right pane, check Show Developer tab in the Ribbon under Top options for working with Excel section.
2. After displaying the Developer tab, create your value listing that you want to add to the combo box. See screenshot:
3. And so go to click Programmer > Insert, under Form Controls, click the Combo Box push button, and and then drag your mouse to describe the Combo Box into your specific place, encounter screenshots:
iv. And then correct click the Combo box, and select Format Control, see screenshot:
5. In the Format Object dialog, click Command tab, then in the Input range field, click 
push to select the data range that you want to add to the combo box, and you lot can change the Drop down lines to your need. Come across screenshot:
6. After finishing the settings, click OK, your combo box has been created successfully as following screenshot shown:
Create ActiveX Control philharmonic box and modify the font size in Excel
With the higher up philharmonic box, y'all can't change the font size, but using the Active Command combo box, yous tin fix the font size for the philharmonic box. Still, creating this combo box is somewhat difficult.
one. Create a list of information that you lot want to use for the combo box, enter one of your data into a blank jail cell, select it and right click to choose Define Name to create a range name for this cell to link the list.
two. In the New Proper noun dialog box, enter a name for your list, select Workbook from the Scope drib down listing, and then click push to select the data listing in the Refer to field. See screenshot:
3. Click OK to finish this operation, and then go to click Programmer > Insert, and click Combo Box under ActiveX Control, so drag your mouse to draw a combo box, see screenshots:
4. Right click the combo box, to choose Properties to fix the properties for the philharmonic box.
5. In the Properties window, in the LinkedCell field, input your prison cell and listing range name that you just created in Footstep i and step 2. Meet screenshot:
6. Then shut this window, and click Blueprint Mode command nether Programmer tab to exit Design Manner.
7. And your combo box is created and set using.
Tips:
If you want to alter the font size of your combo box, please go to click Pattern Style control under Developer tab to entry Design Manner, and correct click the philharmonic box to select Properties.
In the Properties window, click
button at the right of the Font property. And in the popped out Font dialog, specify your font and size for your combo box. See screenshots:
And the font size of your combo box will exist inverse to your setting.
Related manufactures:
How to insert driblet downwardly list in Excel?
How to quickly create dynamic drop downwards list in Excel?
The Best Office Productivity Tools
Kutools for Excel Solves Well-nigh of Your Bug, and Increases Your Productivity by eighty%
- Reuse: Rapidly insert complex formulas, charts and anything that yous accept used earlier; Encrypt Cells with password; Create Mailing Listing and transport emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split up Cells Content; Combine Duplicate Rows/Columns... Prevent Indistinguishable Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Detect and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Bank check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Betwixt Cells Content and Comments...
- Super Filter (save and use filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split up Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Piece of cake deploying in your enterprise or arrangement. Full features 30-twenty-four hour period costless trial. lx-twenty-four hours money back guarantee.
Office Tab Brings Tabbed interface to Function, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Projection.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
waltonbarrispinks.blogspot.com
Source: https://www.extendoffice.com/documents/excel/1432-excel-create-combo-box.html