+ Reply to Thread
Results 1 to 2 of 2

Filter listbox to selected items

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    713

    Filter listbox to selected items

    Hi

    With userform1 listbox1, can I add command button1 to filter listbox to show only selected items, and another button2 to clear filter without unselect selected items?
    listbox using rowsource
    is that possible?

    or show it in new listbox? or any other idea? "no need to show it in msgbox"
    Attached Files Attached Files
    Last edited by Undo; 02-12-2022 at 11:21 AM.

  2. #2
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,264

    Re: Filter listbox to selected items

    with the attached demo - filter with option buttons first - this loads the combobox with appropriate column which selects appropriate row of listbox.
    there is a textbox overlaying the combobox if you type in the relevant item after selecting the option button (column) - the listbox will go to the selection.
    selecting from the listbox fills the five text boxes - the listbox is loaded via an array from the table - rowsource is best avoided at all times.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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] Copy selected listbox items to another listbox
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2020, 10:42 AM
  2. Use Selected Items from ListBox As Filter Criteria, Including Blanks
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 06:13 AM
  3. [SOLVED] Use Selected Items from ListBox As Filter Criteria
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2015, 12:13 PM
  4. [SOLVED] Add Selected Items From One ListBox to Another ListBox on UserForm
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 06:53 PM
  5. 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
  6. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  7. [SOLVED] How to use selected items from Listbox
    By gerard.kompier@shell.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2006, 11:10 AM

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