+ Reply to Thread
Results 1 to 3 of 3

How to Add Rows to Active X Multi-Column Listbox Based Upon Cell Value in Range

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    How to Add Rows to Active X Multi-Column Listbox Based Upon Cell Value in Range

    All,

    I'm having some difficulty in working with an Active X multi-column (15 columns) listbox on a worksheet. I have one table on a separate worksheet (15 columns), and the active x listbox on another.

    Based upon a the value of a certain cell on the listbox worksheet (ex. "Part 1"), i'd like the listbox to populate all table rows that have "Part 1" in the first column of the table, while keeping the column headers static in the listbox.

    I've attached an example workbook that should provide some additional clarity. Any ideas here?

    Thanks!
    Chris
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Re: How to Add Rows to Active X Multi-Column Listbox Based Upon Cell Value in Range

    Hi,

    Maybe this can help. I have added some Range Names to your workbook that is required. I have attached the workbook.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    1. Reply to thread and inform if suggestion was helpful or not
    2. Click on the star (=Add Reputation) if you think someone helped you
    3. Mark [SOLVED] to this thread if solution was found. (On Menu "Thread Tools" > "Mark this thread as solved")

  3. #3
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    Re: How to Add Rows to Active X Multi-Column Listbox Based Upon Cell Value in Range

    Joakim,

    You are a wizard! This works perfectly! Thank you very much.

    Best,
    Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find as you type in listbox control - solution for multi-column listbox - vba dictionary
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2018, 03:42 AM
  2. Copy Multi Rows From Multi Sheets Based On Column Value And Create New Workbooks
    By Huskersippi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2017, 04:51 PM
  3. Load Listbox with rows preselected based upon cell value in a column of each row
    By EverBay1215 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2017, 02:31 AM
  4. [SOLVED] Multi row & column ListBox to worksheet range
    By BanginMyHeadOnMyDesk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 06:47 PM
  5. [SOLVED] Multi-column Listbox - Dynamic range - over 4,000 rows of data
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-12-2013, 04:39 PM
  6. Delete Autofiltered rows from multi-column Listbox
    By kriswhiteley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2012, 08:46 AM
  7. [SOLVED] Multi Column Listbox change based on a selection from a combobox
    By AttalaEA in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-21-2012, 06:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1