+ Reply to Thread
Results 1 to 11 of 11

Filter by Date and Show in LisView

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Filter by Date and Show in LisView

    I have two combobox cmb_Dt_Inc (start date) and cmb_Dt_Fin (end date).

    I need show result in ListView.
    Attached Files Attached Files
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Filter by Date and Show in LisView

    Hi.

    i would like someone help me.

    thanks

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filter by Date and Show in LisView

    Hi marreco

    Your code has only one Filter Criteria, either cmb_Dt_Inc or cmb_Dt_Fin, whichever you've chosen last. You'll need to capture the lower criteria with
    Please Login or Register  to view this content.
    and the upper criteria with
    Please Login or Register  to view this content.
    .
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Filter by Date and Show in LisView

    Hi old friend. are you ok?

    I very confused.
    I traing understand
    ----------------------------------D/m/yyy-----------------------------------------------------------------------------m/D/yyy
    why my combobox has value date (9/7/2013) after avent change, but when i look in sheet (Filtro) in cell A2, has this date(7/9/2013)
    My spreadsheet is received inverted date.
    I do not what to do

    thank you!

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filter by Date and Show in LisView

    Hi marreco

    All the Dates display the same on my platform (7/9/2013)...see attached...

    Dates.jpg

  6. #6
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Filter by Date and Show in LisView

    Hi Jalske

    ok, but i live in brazil, because this i have problem.

    My formate date is.

    DD/mm/yyyy

    thanks

  7. #7
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Filter by Date and Show in LisView

    Hi marreco

    You appear to have two issues working here.

    Issue #1 is the Issue of this Thread regarding Filtering to ListView...I believe I've described the Issue here
    Your code has only one Filter Criteria, either cmb_Dt_Inc or cmb_Dt_Fin, whichever you've chosen last.
    Issue #2 you describe, I assume, is a Formatting Issue and is not an Issue of this Thread. .
    i live in brazil, because this i have problem.

    My formate date is.

    DD/mm/yyyy
    The Code in your Workbook is, to me, quite convoluted. It would take too much of my time to sort through it to understand why you're doing what you're doing. If I understood what you're attempting to do I'd probably need to rewrite the Code so that I understand what's happening.

    I'd suggest, if you didn't write the Code, you contact the person who did and have them look at both Issues. If you wrote the Code then you'll be able to manage the changes.

    Sorry...

  8. #8
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Filter by Date and Show in LisView

    Hi jalaske

    I'd suggest, if you didn't write the Code, you contact the person who did and have them look at both Issues. If you wrote the Code then you'll be able to manage the changes.
    who wrote the code was Greg M. i try to talk to him.

    Maybe maybe I should change all the code, but thanks.

  9. #9
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Filter by Date and Show in LisView


  10. #10
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Filter by Date and Show in LisView

    Quote Originally Posted by marreco View Post
    Hi jalaske

    who wrote the code was Greg M. i try to talk to him.

    Maybe maybe I should change all the code, but thanks.

    Eh???

    Please note that I didn't "write the code" - I made the original code WORK - there's a BIG difference!

    I would agree with the comment that the (original) code IS "quite convoluted".

    Greg M

  11. #11
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Filter by Date and Show in LisView

    Hi, i still stoped, but i glad, maybe one day i can chage my adptation.

    thanks

+ 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. Date formula if positive show, if negative don't show.
    By Cyberpawz in forum Excel General
    Replies: 8
    Last Post: 03-14-2012, 07:49 AM
  2. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM
  3. Replies: 0
    Last Post: 05-12-2010, 05:01 PM
  4. Filter on date and show most recent
    By NMullis in forum Excel General
    Replies: 1
    Last Post: 03-10-2010, 12:51 PM
  5. FILTER: show/don't show selection with tickboxes
    By ancharwashere in forum Excel General
    Replies: 2
    Last Post: 10-11-2005, 05:05 PM

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