Results 1 to 3 of 3

Thread: Pop-up calendar

  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post
    Hi loungers....I would like to add a pop-up calendar to the 'date' columns in the attached spreadsheet......I tried using the INSERT-OBJECT-CALENDAR CONTROL but all that did was make a calendar that was static. I have seen an add-in from Office-Kit.com (for about $20) that would work in my Excel but I want something built in to the s/sheet so that if someone clicks a cell in one of the date columns, it opens a calendar and they just move to a date and click it to enter that date in the cell. Is this easy to do? Thanks.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    The Calendar control uses an external file called mscal.ocx which every user must have. It can not be made part of your workbook.

    You could use a calendar created as a userform - see for example http://cpap.com.br/orlando/#calendar (addin)or http://www.vbaexpress.com/kb/getarticle.php?kb_id=543 (VBA code that you could modify if desired)

    Steve

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    If you have the Microsoft DTPicker available this example might work.
    I've stuck in a couple of traps but not all.
    It uses a UserForm with DatePicker.

    I have run it off the DOUBLE click event, BUT
    if you change it to Selectionchange Event it ought
    to respond to clicking in the cell.

    This may not be what you want, but it does show a possible solution

    [attachment=87922:Sample for pop-up calendar With Date Picker.xls]
    Attached Files Attached Files
    Andrew

Posting Permissions

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