REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

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..,

Combo Box Excel ActiveX Control Object

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.

    1. Go To Developer Tab and then click Insert from the Controls
    2. Click on the Combo Box from the Activex Controls group.
    3. Drag a Combo Box on the Worksheet.
    4. Right click on the Combo Box (Design Mode should be turned ON).
    5. Click on properties from the available list.
    6. On the left side find ‘ListFillRange’ from the available properties of a Combo Box.
    7. On the right side mention the Input Range. Ex: ‘A1:A5’. Please find the below screen shot for the same.

ComboBox Excel ActiveX Control _ListFillRange

    1. 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.

ComboBox Excel ActiveX Control

    1. You can link the Combo Box to a Worksheet cell. Right click on Combo Box and select properties.
    2. On the left side find ‘LinkedCell’ from the available properties of a Combo Box .
    3. On the right side mention the linked cell as ‘E3’. Please find the below screen shot for the same.

ComboBox Excel ActiveX Control5

  1. 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.

Read More …

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.

Read More …

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.

Read More …

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Last Updated: March 2, 2023

5 Comments

  1. ekacan October 9, 2015 at 1:48 AM

    I would like to create a VBA procedure that adds an ActiveX combo box in a worksheet, and sets the properties, specifically the ListFillRange, Linkedcell, and Boundcolumn. I would like the placement to be on the row right after the last populated cell on column D.

    I understand that I will create a button that runs a procedure which adds a listbox, but I have not been able to change it’s properties.

    I appreciate the help.

  2. sousilva October 27, 2015 at 9:27 PM

    Try using “object”: (there are other ways, like using Shapes, I use this because I also need the objOLE for other reasons)


    Dim wsRec As Worksheet
    Dim sName As String
    Dim objOLE As OLEObject

    Set wsRec = ThisWorkbook.Sheets(“Recs”)

    wsRec.OLEObjects.Add(ClassType:=”Forms.ComboBox.1″, Link:=False, DisplayAsIcon:=False, _
    Left:=180, Top:=18.75, Width:=129, Height:=18.75).Name = sName
    ….
    Set objOLE = wsRec.OLEObjects(sName)
    objOLE.Object.BorderStyle = 1
    objOLE.Object.SpecialEffect = 0

    Set objOLE = Nothing

    Set wsRec = Nothing

  3. pranav prakash February 16, 2018 at 1:28 PM

    Thanks a lot for this bit of code helped me a lot really

  4. Sree June 27, 2018 at 3:58 AM

    Thankyou. This code helped me in understanding activeX combobox controls

  5. James August 20, 2020 at 3:31 PM

    Same here – very helpful.
    Thank you

Leave A Comment