+ Reply to Thread
Results 1 to 2 of 2

Filtering a Listbox and Showing a "Live" Version of the Filtered Data

  1. #1
    Registered User
    Join Date
    07-23-2019
    Location
    Minnesota
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    2

    Filtering a Listbox and Showing a "Live" Version of the Filtered Data

    I have a "Data" worksheet that I want users to be able to edit the data in this worksheet by using a Form (keep the data uniform). When the user opens the initial form (UserForm1), this will display all of the rows of data that they can select from to edit. Because this data set is large (will be 6,000 rows of data), I have included textboxes in the form so they can filter down to the data they want to edit. The textboxes filter the "Data" worksheet, but my listbox doesn't show the "live" filtered version as the user uses the textboxes. Below is the code I am using to add the data to the Listbox and the GetRange function (I will attach a copy of the spreadsheet also). I know excel has the .SpecialCells(xlCellTypeVisible), but I cannot figure out how to use this to show the filtered data.

    I have seen people use the .AddItem and loop through the data using the .List creating an array list, but that seems to be slow, cannot add more than 10 columns, and I cannot use multiple textboxes to filter at the same time unless the user types and then selects a button which uses all of the textbox data.

    Please Login or Register  to view this content.
    Please let me know if I was unclear on anything or if you need a better explanation.

    Thank you!!

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Filtering a Listbox and Showing a "Live" Version of the Filtered Data

    see if the attached approach works for you - the option buttons load the one combobox with appropriate data - selecting this then loads the listbox - select from listbox loads your textboxes which you can edit and save (update) this dynamically reloads the data ready for another choice - you say your data in arrays is slow - (do not blink or you will miss the event)
    there are no search routines involved - the listrow counter is contained in the last column of the array enabling instant data access.
    any queries post back on this site.
    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. Replies: 0
    Last Post: 08-08-2020, 06:29 AM
  2. [SOLVED] Filtered data in listbox
    By thomasghi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2019, 08:35 AM
  3. Filtering Values not showing all data
    By ransombla in forum Excel General
    Replies: 6
    Last Post: 08-02-2017, 02:30 PM
  4. Populate (ca 200) Txtboxes depending on listbox selection, live-filter for listbox &1 more
    By InternInNeed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2016, 09:56 AM
  5. Filtering filtered data
    By Jeff K in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-21-2013, 12:54 PM
  6. Replies: 2
    Last Post: 06-06-2012, 03:06 PM
  7. Using Filtered Data in Listbox
    By sfinney in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2005, 03:37 PM

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