+ Reply to Thread
Results 1 to 6 of 6

ListBox Filter

  1. #1
    Registered User
    Join Date
    06-25-2015
    Location
    Mauritius
    MS-Off Ver
    2013
    Posts
    5

    Unhappy ListBox Filter

    Hi
    I need a big help from you.
    In my excel - in tab "View today Record" i want the list box the show only data with date which are today.
    The list box is up to 6 columns

    Can you please help ?
    Thanks to refer to the attached file.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: ListBox Filter

    File is corrupt.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: ListBox Filter

    One way
    1) Add a new sheet and name it as "Hidden", then make it hidden (not visible)

    2) change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-25-2015
    Location
    Mauritius
    MS-Off Ver
    2013
    Posts
    5

    Re: ListBox Filter

    Thanks you very much
    Can i put it as a command button - so that i dont to close and open the excel foe it to show up the today's date?

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: ListBox Filter

    What do you mean?

    You have userform with multi page and "View Today Record".

  6. #6
    Registered User
    Join Date
    06-25-2015
    Location
    Mauritius
    MS-Off Ver
    2013
    Posts
    5

    Re: ListBox Filter

    Never mind i got
    I put the code with a command button named as "Refresh"

    Thanks again

+ 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. ListBox Filter
    By rlinares67 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2015, 01:39 PM
  2. [SOLVED] Listbox filter
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2014, 01:18 AM
  3. [SOLVED] Filter data in listbox
    By Petter120 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 05:08 PM
  4. [SOLVED] Data filter from a ListBox
    By Glenn Kennedy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2014, 10:25 PM
  5. Filter Listbox
    By Sniper in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-27-2014, 05:16 AM
  6. Filter listbox
    By sohaila in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2013, 03:26 AM
  7. listbox vs filter
    By ahmad123 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-14-2011, 02:13 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