+ Reply to Thread
Results 1 to 3 of 3

Search within Date Range

  1. #1
    Registered User
    Join Date
    10-25-2019
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    13

    Search within Date Range

    Hello Good day, I am doing a simple vba project. But there is a problem arises
    I have already a search box and results populate in the listbox but i want to sort or show only the results from the specific date range,
    and i want the results from listbox to show in cells.
    i hope you can help me.

    thank you
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Search within Date Range

    I took the liberty of changing your textboxes to comboboxes, it's easier to select from a combobox than to type in something.


    Code in the userform

    In the attachment. Select the name first then select the dates.


    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-25-2019
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    13

    Re: Search within Date Range

    Thank you for this, this perfectly working.

+ 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. Task search as per date range and a name
    By Abhishek3211 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-15-2019, 04:51 PM
  2. [SOLVED] How to search data between date range
    By devawad in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-22-2017, 07:46 AM
  3. Search date range for quantity sum
    By tavwtby in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 10-21-2016, 05:14 PM
  4. Search large date range with narrow filetered range
    By druth in forum Excel General
    Replies: 14
    Last Post: 08-02-2014, 09:01 AM
  5. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  6. Search range for a date
    By denfan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2012, 10:20 AM
  7. Search for keywords in a date range
    By excelgroupie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 02:40 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