+ Reply to Thread
Results 1 to 5 of 5

Display Items in Listbox based on filtered data

  1. #1
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Display Items in Listbox based on filtered data

    Hi Gurus,

    Could you please help me with my problem.

    I have data in Sheet1 and a Userform that has a Commandbutton and a Listbox.
    What I want to accomplish is, display the 'ACCOUNT NUMBERS' in Listbox that is in 'WAITING FOR APPROVAL' via a commandbutton.

    I have attached my file.

    Thanks in advance gurus!
    Attached Files Attached Files
    Last edited by puuts; 05-13-2014 at 09:54 PM.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,340

    Re: Display Items in Listbox based on filtered data

    Hi puuts,

    Thanks in advance gurus!
    Sorry, seems like you got me

    Instead of assigning the below to a command buton (you can still do it that way if you like) you can use this which will run each time the form is opened from Sheet1:

    Please Login or Register  to view this content.
    Regards,

    Robert
    Last edited by Trebor76; 05-13-2014 at 10:25 PM.
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Re: Display Items in Listbox based on filtered data

    Amazing! Perfectly done! this is exactly what i want!

    Thank you so much Robert!

  4. #4
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,340

    Re: Display Items in Listbox based on filtered data

    Thanks for the feedback and you're welcome

  5. #5
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Re: Display Items in Listbox based on filtered data

    Hi Robert,

    Sorry for missing this out, how can i amend the code if i want to include the header? I mean the 'Account Number' text. I want it also to include to be display in the listbox

+ 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] Listbox items display briefly, then disappear?
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-30-2013, 06:35 AM
  2. 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
  3. Replies: 1
    Last Post: 08-08-2012, 01:17 AM
  4. display data based on selection from listbox, total newbie
    By trek4heroes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2012, 08:44 PM
  5. How to display Items in ListBox
    By sam in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-28-2006, 09:50 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