+ Reply to Thread
Results 1 to 2 of 2

Filter result show in the Listbox

  1. #1
    Registered User
    Join Date
    05-20-2022
    Location
    New York
    MS-Off Ver
    2016
    Posts
    1

    Filter result show in the Listbox

    Hello all experts,
    I urgently need a solution to show Filtered data in a Form. A Listbox in a Form is required to display the filtered data.
    It shows all data inside the Listbox but is not able to show the filtered data.
    In "worksheet1", I need to filter column A with a different user name, how can I do it. Please help.

    Please Login or Register  to view this content.
    Thank you very much,
    Curiousyoung60
    Last edited by jeffreybrown; 05-20-2022 at 09:23 PM. Reason: Please use code tags!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Filter result show in the Listbox

    Your explanation of your question is not complete. For example: Do you mean you are using a UserForm, or you have formatted a worksheet as a form? You said you need to filter column A for a user name but where do user names appear in your worksheet? What data is in your listbox? What is the "different user name" you need to filter for?

    Your next step should be to attach your actual Excel file with sample data. See yellow banner at the top of the page. If we cannot figure out your question from context after reviewing the file than at least at that point we'll be able to ask specific questions.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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: 1
    Last Post: 02-10-2018, 11:35 AM
  2. [SOLVED] Want to Show Filtered data in Listbox with Tickbox Option to Filter data
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2017, 11:55 AM
  3. [SOLVED] How to filter a table using textbox and show filtered data in listbox (userform)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2017, 10:31 AM
  4. Filter Listbox using textbox, Select one result and assign values to label
    By raiken20 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-27-2016, 08:11 PM
  5. [SOLVED] sum using Listbox after show result in Texbox
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2014, 12:43 PM
  6. [SOLVED] Want to show name without duplicates Using FIlter Data Using ListBox
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2014, 01:50 AM
  7. Filter excel with values populated in combobox and show result
    By teodormircea in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2013, 11:24 AM

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