+ Reply to Thread
Results 1 to 4 of 4

Setting date picker date and having 2 columns to each date for excel calendar

  1. #1
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    Setting date picker date and having 2 columns to each date for excel calendar

    Hi, Its hard to give a good description of what the problem in the short title, so im going to explain it here. This file is a leave tracker for staff and users will either forecast their leave in advance or fill it up when they come back from say medical leave.
    First problem: On the userform, textbox1 and textbox2 when clicked, shows a date picker. It currently shows today's date when it pops up, which is fine. What i want to achieve is when a user selects a date that is maybe 1 month ago, for example 7 Nov 2017, i want the date picker from textbox2 to show 7 Nov 2017 rather than today's date again.

    Second problem: I have received feedback that users would like to split the date into AM / PM to facilitate multiple entries on the same day. For example, a staff may want to take half day annual leave in the morning and half day child care leave in the afternoon. Current file format does not support more than 1 entry in the cell other than putting the second leave type into a comment box.

    Have attached the file and print screen of the outcome for problem 2. Any help is appreciated.
    Last edited by bqheng; 12-18-2017 at 04:10 AM.

  2. #2
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    Re: Setting date picker date and having 2 columns to each date for excel calendar

    Can anyone help please?

  3. #3
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    Re: Setting date picker date and having 2 columns to each date for excel calendar

    Can anyone help please?

  4. #4
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    Re: Setting date picker date and having 2 columns to each date for excel calendar

    Can anyone help please?

+ 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. Replies: 8
    Last Post: 03-08-2017, 11:00 PM
  2. [SOLVED] Change Date with Date Picker If Date Less Than 7 Days From Another Date
    By Macfool in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-16-2016, 09:10 AM
  3. Calendar / Date Picker - Only Choose Sunday
    By stevie875 in forum Excel General
    Replies: 2
    Last Post: 02-02-2016, 01:01 PM
  4. Date Picker / Calendar for Combobox
    By sthiru in forum Excel General
    Replies: 9
    Last Post: 11-24-2015, 04:30 PM
  5. Use Calendar (Excel 2007) and the Date Picker (Excel 2010) in same project...
    By jpcsolutions in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2011, 01:52 AM
  6. Replies: 3
    Last Post: 09-06-2010, 02:31 PM
  7. Replies: 1
    Last Post: 07-11-2005, 08:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1