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

ListBox ActiveX Control is used to display list of items to a list. ListBox can be used on the WorkSheet. Please find more details about ActiveX ListBox Control in the following chapter. You can see how to load items to listbox, how to move items from one listbox to another listbox, how to select items in a listbox, etc..,

List Box Excel ActiveX Control Object

VBA ActiveX ListBox Control on the Worksheet: Using ListFillRange

Please find more details about VBA ActiveX List Box Control and how we are adding it on the Worksheet. Here, we are using ‘ListFillRange’ Property of List box to add or load items to list box.

    1. Go To Developer Tab and then click Insert from the Controls
    2. Click on the List Box from the Activex Controls group.
    3. Drag a List Box on the Worksheet.
    4. Right click on the List 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 List Box.
    7. On the right side mention the Input Range. Ex: ‘A1:A5’. Please find the below screen shot for the same.

Excel VBA ListBox ActiveX Control4

    1. On the Worksheet go to range ‘A1:A5’ enter the input data. Automatically you can see the input data loads into the List Box. Please find the below screen shot for the same.

Excel VBA ListBox ActiveX Control5

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

Excel VBA ListBox ActiveX Control6

  1. Now, you can see the selected list box item on the worksheet cell (‘E3’) (Design Mode should be turned OFF).

More Details About the ListBox Control

VBA ListBox Excel Macros Examples Codes Adding Clearing Multiple Items

Please find the following link for more details about VBA ListBox Excel Macros Examples and Codes Adding and Clearing Multiple Items.

Read More …

VBA to Remove Duplicates in ListBox Excel

Please find more details about Remove Duplicates in ListBox in Excel VBA.

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

One Comment

  1. Abhijeet October 16, 2015 at 4:04 PM

    can anyone help me. if i have a cell address from another sheet of same workbook in listbox. If i select that i want to go to that sheet and show the cell selection.
    Please help me with it on mail as i am so new to vba.

Leave A Comment