Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Use a Calendar (2002)

    I would like to have a calendar for use within a worksheet. Selecting a date should feed its value to a cell. (Something similar to the Calendar control available within Access?!). Any idea where I might find such a thing? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Use a Calendar (2002)

    If you (and your users) have Access, you can use the calendar control that comes with Access:
    - Display the Control Toolbox.
    - Click the More Controls button (the last one on the Toolbox).
    - Select Calendar Control 10.0.
    - Click on the worksheet or drag a rectangle.
    - Click the Properties button on the Toolbox.
    - Set the LinkedCell property to the cell you want to display the selected date.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use a Calendar (2002)

    No Access on their computers I'm afraid. Is it possible to download it? Thanks, Andy.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Use a Calendar (2002)

    You need to have the Office Developer Edition for the license to distribute the calendar control to users who don't have Access.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use a Calendar (2002)

    In which case, is their an alternative calendar that performs the same function? Andy.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Use a Calendar (2002)

    There are probably several commercial replacements. Here is a free one; I haven't tried it myself: CCRP DateTime Picker Control for VB6.

  7. #7
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use a Calendar (2002)

    Hans, I have to admit that I can't recall where the attached comes from. I found it on some site. I apologize for not being able to give credit to the person who did develop this.

    Anyway it might do what is needed.
    Attached Files Attached Files

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Use a Calendar (2002)

    Hi kiazd,

    That is a nice example in itself, but it uses the Calendar Control that comes with Microsoft Access. The example will not work on a PC that doesn't have the Access calendar control installed.

Posting Permissions

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