+ Reply to Thread
Results 1 to 2 of 2

DatePicker for multiple dates

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    belgium
    MS-Off Ver
    2013
    Posts
    22

    Question DatePicker for multiple dates

    I have an Excel file in which the user can register an event (coming to work by bike). The registration is done using an User form, works perfectly.
    The registration however must be done by date, this for HR reasons, which means that the user has to fill in multiple times (for multiple events) the userform, and that is indeed time consuming.
    What i was thinking of, i know you can set up a datepicker to select the date on a calendar, in stead of just typing the date.
    My question now, could it be possible to set up thedatepicker in which the user can select multiple dates? Then i could just loop my current statement with the multiple dates selected in the datepicker. This would speed up the registration process.

    Is this possible? How do i even begin?

    thanks.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: DatePicker for multiple dates

    Instead of accessing the date and time from date picker directly in your code, rather use datepicker change event to store the dates in a listbox and then you can loop through the listbox items to access all the dates and times.

    Something like this....

    Please Login or Register  to view this content.
    So each time user picks up a date, the date will be added in the listbox1 and you can use the listbox items in your code.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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. ActiveX DatePicker: Specify Certain Available Dates/Frequency by Listbox Choice
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-31-2013, 07:11 PM
  2. Missing Datepicker
    By Steveg48 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2012, 11:41 AM
  3. use datepicker without mscomct2.ocx
    By johnsmith22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2010, 11:50 AM
  4. Using the JR Datepicker
    By madhg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2009, 12:44 PM
  5. [SOLVED] DatePicker
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2006, 09:15 PM

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