+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Adding a Calendar date picker to a certain Cell

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    san diego, california
    MS-Off Ver
    Excel 2003
    Posts
    18

    Exclamation Adding a Calendar date picker to a certain Cell

    Okay Guys,

    I have searched the threads as best i know how to, but cant seem to find a post that is helping me. i found one relating to it somewhat, which was picking a date then saving it to another sheet in the workbook. I tried to edit the code to what i needed but it did not work.

    So.. First off, i am working on EXCEL 2007. i have a small very limited VB2008 knowledge. but the computer i am using does not have it on it nor can i install it.

    The project i am working on is once again for the Navy. It is a qualification tracker.

    The first sheet labeled EDIT QUALIFICATIONS is so that the person can add delete or put a completion date down for the qual for a specific person.

    The second sheet labeled PRINT PAGE is to be able to print out the list of quals a person has gained.

    the third sheet labeled DB is the data base / Info sheet.

    I am going to attach a workbook and on page on have a cell colored yellow and labeled where i want the pop up calendar.

    I also am going to be asking for help (i can forsee the future) about how to add info into the DB sheet when entered into the first sheet...... but thats another thread....

    thanks in advance guys you always come through for me.
    Attached Files Attached Files
    Last edited by flikkem; 09-01-2010 at 05:48 PM.

  2. #2
    Forum Contributor
    Join Date
    07-29-2008
    Location
    New York
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    145

    Re: Adding a Calendar date picker to a certain Cell

    flikkem,
    Take a look at this site
    HTML Code: 
    Xrull.

  3. #3
    Registered User
    Join Date
    07-15-2009
    Location
    Brooklyn, NY
    MS-Off Ver
    Excel 2007 AND Excel 2003
    Posts
    10

    Re: Adding a Calendar date picker to a certain Cell

    For a 3rd party solution see (yes might not be right for your needs):
    Wincalendar Excel popup Calendar

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Adding a Calendar date picker to a certain Cell

    There doesn't seem to be a calendar in the workbook. There's different example s here

    http://excel-it.com/free_addins.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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