+ Reply to Thread
Results 1 to 5 of 5

Extract data between two dates to listbox

  1. 02-14-2015, 01:25 PM #1
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Extract data between two dates to listbox

    Hello everybody
    I have data in column A & B (Tourn. and Dates)
    I want to use a userform to search between two dates and the results to be unique in listbox1
    Hope the attachment will calrify my request
    Thanks advanced
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-16-2015, 07:07 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Extract data between two dates to listbox

    Any help with that thread?
    Reply With QuoteRegister To Reply
  3. 02-16-2015, 05:11 PM #3
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Extract data between two dates to listbox

    Hi Yasser,

    Put this in your Userform code right under the unload code:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  4. 02-16-2015, 05:36 PM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Extract data between two dates to listbox

    Thanks a lot Mr. xladept for your help
    I typed two dates : 1/1/2014 and 1/2/2014 and I got an error message 1004 at this line
    Please Login or Register  to view this content.
    But it works with some other dates
    Another point I want unique values.. Is that possible?
    Reply With QuoteRegister To Reply
  5. 02-16-2015, 07:07 PM #5
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Extract data between two dates to listbox

    Hi Yasser,

    Thanks for the rep!

    Try this:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extract data between two dates
    By Ogi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-24-2014, 07:19 AM
  2. [SOLVED] Extract the data selected in ListBox to cells
    By boss1982 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2014, 09:27 AM
  3. Extract data between two dates
    By grey_hair in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2011, 10:25 AM
  4. [SOLVED] Extract data from SQL Server table into excel using Listbox Selection as criteria
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2010, 07:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1