![](/uploads/1/2/7/3/127320067/409530545.png)
How to populate Combo Box with data of Named Range in Excel?You can specify a Combo box (ActiveX Control) with data of a certain range by adding the range into the ListFillRange properties of the combo box. But do you know how to populate a Combo box with data of a named range in Excel? For example, you have named a range of cells in your worksheet, and now, need to specify this range name into a Combo box. When selecting the range name in one combo box, all cell values in this named range will be populated in another Combo box automatically. This article will introduce a VBA method to solve this problem. Please do as follows to populate Combo box with data of a named range in Excel.1.
Please select the whole headers (in this case, I select A1:E1) in your worksheet, and then type a name into the Name Box as below screenshot shown.2. Select each column data except its header, and then name the column separately in the Name Box. See screenshot:In this case, I named range A2:A8, B2:B8, C2:C8, D2:D8 and E2:E8 as Date, Shop, Items, Sales and Weekday separately.3.
Then insert a Combo box by clicking Developer Insert Combo Box (ActiveX Control). See screenshot:4. Repeat the step 3 to insert another Combo box into the worksheet.5. Game textures iron clothes. Right-click the sheet tab, and then click View Code from the context menu. See screenshot:6. The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%. Reuse: Quickly insert complex formulas, chartsĀ and anything that you have used before; Encrypt Cells with password; Create Mailing List and send 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 Cells Content; Combine Duplicate Rows/Columns.
![Using Using](/uploads/1/2/7/3/127320067/151792753.png)
When you manipulate or loop through range names in VBA you will need to use the Names. WorkbookParameter 'new in Excel 2007 End With End Sub.
![](/uploads/1/2/7/3/127320067/409530545.png)