Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Hi,

    I have an excel spreadsheet that I send to several employees every week to update. I was wondering if there was some way to add a calendar pop-up when I click on my column Start Date and End Date? I know I can format the cells to be a "date" but that wouldn't be any fun. How else do we learn new things...
    Does anyone have any ideas how I can add a calendar to pick a date from? My Start Date column is B2 and End Date is C2. I also need something that is available on the workbook and doesn't require my users to download any add ins.

    Much appreciated!

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Does this do what you want?
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post
    I created my own calendar control a while back. I had been using mscal.ocx, but then for a number of users the file was getting deleted by a corporate IT logon script.
    I should confess that I copied the idea from somebody else (e.g., using command buttons for each day), but I tidied it up a lot.

    I have it initiated by a command button, but you could use a Worksheet_SelectionChange event if you'd rather.
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by ColinBurrows View Post
    I created my own calendar control a while back. I had been using mscal.ocx, but then for a number of users the file was getting deleted by a corporate IT logon script.
    I should confess that I copied the idea from somebody else (e.g., using command buttons for each day), but I tidied it up a lot.

    I have it initiated by a command button, but you could use a Worksheet_SelectionChange event if you'd rather.

    Wow nice calendar! Is there a way to select a date from the calendar and it fill in the date in my column called start date?

  5. #5
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by John Hutchison View Post
    Does this do what you want?
    Hi, I don't see anything attached. Thank you.

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by Corden View Post
    Hi, I don't see anything attached. Thank you.
    There was nothing attached. The word this in my previous post is a hyperlink. (It is blue)
    Regards
    John



  7. #7
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •