+ Reply to Thread
Results 1 to 5 of 5

Create a Filtered list for a Multicolumn listbox VBA

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Mumbai, IN
    MS-Off Ver
    Office 365
    Posts
    97

    Create a Filtered list for a Multicolumn listbox VBA

    HI,

    I have four columns that show certain data. In the column D, shows either OVERDUE, DUE, PENDING. currently i use the following code to update that list in to a listbox


    Please Login or Register  to view this content.
    How do i add a filtered list of only the rows which show overdue to show up in the listbox??

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

    Re: Create a Filtered list for a Multicolumn listbox VBA

    Hello yoursamrit2000,

    The code below is a button on the UserForm used to filter the data using the fourth column in the ListBox.

    It removes all entries that don not match "Overdue".

    Please Login or Register  to view this content.
    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
    09-27-2012
    Location
    Mumbai, IN
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Create a Filtered list for a Multicolumn listbox VBA

    HI
    please check the following file
    Attached Images Attached Images
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-27-2012
    Location
    Mumbai, IN
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Create a Filtered list for a Multicolumn listbox VBA

    chcek three files
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-27-2012
    Location
    Mumbai, IN
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Create a Filtered list for a Multicolumn listbox VBA

    All the files with the macros
    Attached Files Attached Files

+ 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] Populate multicolumn listbox
    By Petter120 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2014, 07:56 AM
  2. Multicolumn dynamic Listbox - Remove Duplicates in Listbox
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2014, 12:30 PM
  3. Having problems populating a multicolumn listbox changing Listbox column with a loop.
    By Aristizabal95 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2013, 12:41 PM
  4. Copy Selected items from multicolumn, multiselect listbox to another listbox
    By Willigb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 11:27 AM
  5. Multicolumn ListBox
    By pankaj2610 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-01-2013, 11:59 PM
  6. Search Range, List Results in MultiColumn ListBox
    By LiamPotter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2008, 11:44 AM
  7. [SOLVED] Filtered List as Listbox RowSource
    By Ken McLennan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-20-2005, 08:05 PM

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