ComboBox ActiveX Control is used to store and display list of items to a list. ComboBox can be used on the WorkSheet. Please find more details about ActiveX ComboBox Control in the following chapter. You can see how to load items to a Combo Box, how to get the value of combo box items, etc..,
VBA ActiveX ComboBox Control on the Worksheet: Using ListFillRange Property
Please find more details about VBA ActiveX Combo Box Control and how we are adding it on the Worksheet. We are using ‘ListFillRange’ Property of Combo Box to add or load items to Combo Box.
- Go To Developer Tab and then click Insert from the Controls
- Click on the Combo Box from the Activex Controls group.
- Drag a Combo Box on the Worksheet.
- Right click on the Combo Box (Design Mode should be turned ON).
- Click on properties from the available list.
- On the left side find ‘ListFillRange’ from the available properties of a Combo Box.
- On the right side mention the Input Range. Ex: ‘A1:A5’. Please find the below screen shot for the same.
- On the Worksheet go to range ‘A1:A5’ enter the input data. Automatically you can see the input data loads into the Combo Box. Please find the below screen shot for the same.
- You can link the Combo Box to a Worksheet cell. Right click on Combo Box and select properties.
- On the left side find ‘LinkedCell’ from the available properties of a Combo Box .
- On the right side mention the linked cell as ‘E3’. Please find the below screen shot for the same.
- Now, you can see the selected Combo Box item on the worksheet cell (‘E3’) (Design Mode should be turned OFF).
More Details About the ComboBox Control
VBA ComboBox Excel Macros Examples Codes Adding Clearing Items
Please find more details about Remove Duplicates in Combo Box in Excel VBA.
VBA Remove Duplicates in ComboBox
Please find the following link for more details about VBA Combo Box Excel Macros Examples and Codes Adding and Clearing Items.
Excel VBA FAQs: Frequently Asked Questions
Please find the most frequently asked questions and answers for your reference. These are explained more detailed way with examples.