+ Reply to Thread
Results 1 to 4 of 4

Listbox to select and display multiple matching information from range

  1. #1
    Registered User
    Join Date
    08-09-2011
    Location
    london england
    MS-Off Ver
    Excel 2003
    Posts
    3

    Listbox to select and display multiple matching information from range

    I'm trying to use a listbox and button to select and display bits of information from an array of data. Let me layout the format of my sheet to make it a bit clearer.

    On one sheet I have an array of data, 10 columns by approximately 1200 rows. My columns are headed Course title, date, venue, room, type, letter, start time, end time, learners, and group leader on columns C through L. Below the column headers from row 2 down I have each piece of data.

    On a second sheet I have created a Listbox with each of the possible course titles listed. There are multiple instances of each course title however they are all on different dates or locations. I'm looking for a way for a user to be able to click a button after selecting a course title from the listbox and have it populate an area below the listbox and button with every matching piece of data from the array.

    I guess it'd be done with a recursive match command but it's been a number of years since I've done any real VBA programming so my skills are very rusty. Any help would be much appreciated.

    Thanks.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Listbox to select and display multiple matching information from range

    Hello Mewhew,

    Welcome to the Forum!

    It would be easier to suggest possible solutions if you post your workbook. Please change or remove any information that might be sensitive or confidential before you post it. Please include before and after examples of how the data should appear and any other comments that may be helpful.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    08-09-2011
    Location
    london england
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Listbox to select and display multiple matching information from range

    Alright I've attached the abstract of the sheet I'm working from.

    The sheet titled SheetList contains the data array I'm trying to extract the data from. The sheet titled LookUp contains the controls and where the lookup will take place. the idea is that a user can select a course title from the drop down box and then click lookup and have all the matching courses from SheetList populated below. So if the user were to select Access Business then click the button both dates for Access business would be looked up on SheetList and then entered into the table below.I'm aware of the match command to lookup data but I don;t know how to get that to move through the entire array of data on SheetList and return all the matches.

    Thanks in advance to anyone who can assist with this.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-09-2011
    Location
    london england
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Listbox to select and display multiple matching information from range

    Bumping to hopefully get some help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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