+ Reply to Thread
Results 1 to 2 of 2

Listbox multi selection filter

Hybrid View

ahmad123 Listbox multi selection filter 06-13-2011, 10:39 AM
romperstomper Re: Listbox multi selection... 06-13-2011, 11:02 AM
  1. #1
    Registered User
    Join Date
    05-24-2011
    Location
    montreal
    MS-Off Ver
    Excel 2003
    Posts
    11

    Listbox multi selection filter

    Hi folks,

    I have a userform containing a listbox. In this listbox, theres data imported from a column ("Ext Co Visibility Ds") in a big spreadsheet.
    What i need to do is to give the user the capability to filter the big spreadsheet by selecting multiple lines in the listbox.

    The listbox has to act like a filter for the column "Ext Co Visibility Ds". By filtering that column the user will see the rows corresponding to his selection in the big spreadsheet.

    in the attached file they're my file and my code behind.

    In sheet2 u will find the button that has to create a listbox, but the problem is when i select options in this listbox, nothing happens !!!

    And can u please modify the code so i will be able to make multi selections in the listbox ???


    Thanks to the Gurus
    Attached Files Attached Files

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,976

    Re: Listbox multi selection filter

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this.

    Please add links to any and all cross-posts to your first post here.
    Everyone who confuses correlation and causation ends up dead.

+ 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