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



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

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.
  8. 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.
  9. You can link the list box to a Worksheet cell. Right click on List box and select properties.
  10. On the left side find ‘LinkedCell’ from the available properties of a List Box.
  11. On the right side mention the linked cell as ‘E3’. Please find the below screen shot for the same.
  12. 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 …


One Comment

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

    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

Related pages

excel if statement examples textuses of macros in excelnested if excel 2007identifying duplicates in excelexcel hide buttonhow to sort data in excel 2007how to unlock formulas in excelhow to delete repeated cells in excellen function in excelhow to unhide columns in excel 2013function excel vbasample project plan template excelexcel merge tabsexcel match function examplevba range copyexcel vba cells rangehow to paste special in excelvlookup vs hlookuphlookup excel 2010 examplelogical functions in excel with exampleswhat does vlookup mean in excelexcel chart wizard 2010macro programing in excelprogrammer interview questions and answershow to protect excel sheet from deletingddl sql commandshow to access vba in excel 2007offset formula excelbasic excel macro examplesunlock a protected excel sheetconvert from excel to xmlexcel 3d scatterexcel vba saveas file formatexcel vba import text filegantt chart in excel 2003ado connection in vbelseif excelexcel delete duplicate rowsql query in excelsas sql tutorialbusiness analyst interview questions for freshersexcel vba delete selected rowsstatic vbarun a macro in excel 2007extract hyperlink from excelexcel find duplicates in a columnshortcut key for hide in excelms word meeting minutes templateexcel formula countifswot analysis presentation templateexcel check boxinstr examplesbuilding macros in excel 2010advanced filter in excel 2010excel vba seriesvba averagedashboards excelexcel vba integer rangeexcel macro warningunhide column a in excel 2013hlookup function in excelpivot tables tutorialadodb odbc connection stringvlookup excel vbaunlock vbaexcel create macro buttonconsolidate cells in excelis null vbaselection in excel vbacalendar template excel 2014delete entire row vbahow to learn formulas in