Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Load filtered data to listbox instead of worksheet
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,926
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Load filtered data to listbox instead of worksheet

    I will find a way to use some tricks in switching between years.
    So now how do we get the filtered data into the listbox as before?
    You could allow user to select month(s) on the userform

    How do you want to filter?
    - single month only
    - range of months (example FROM Jan 2019 TO March 2019)
    - whole of 2019
    etc

  2. #12
    Board Regular kelly mort's Avatar
    Join Date
    Apr 2017
    Location
    Suhum, Ghana, West Africa
    Posts
    1,527
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Load filtered data to listbox instead of worksheet

    Since the filter could handle for a single year, what I did was place a combobox and load it with "This Year" and "Last Year".

    And adjacent it is other combobox with the months January to December. So when I select "This year" and then say January, then I set cell D1 value to 01-01-2019 before run the filter.

    It's running cool and I am okay with that.


  3. #13
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,926
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Load filtered data to listbox instead of worksheet

    So.... do you need further help?

  4. #14
    Board Regular kelly mort's Avatar
    Join Date
    Apr 2017
    Location
    Suhum, Ghana, West Africa
    Posts
    1,527
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Load filtered data to listbox instead of worksheet

    Quote Originally Posted by Yongle View Post
    So.... do you need further help?
    No thanks. I will get back here when I get locked somewhere
    There Is Always A Better Way

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •