+ Reply to Thread
Results 1 to 6 of 6

How to insert a calendar in a cell?

  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    34

    How to insert a calendar in a cell?

    Hello, can I have a calendar in a cell, that is, when I click on cell A1, for example, a calendar appears to choose the date and make the registration date in the same cell A1.

    Thanks.

    Best regards.
    Last edited by jorgebarata; 11-11-2013 at 07:03 AM.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to insert a calendar in a cell?

    @ Sixthsense

    Perfectly fine title. I am not sure how else one could describe it. Do you? I think it would be nice if a moderator or whoever posts this warning message take a minute to think how differently this issue has to be described, and make a suggestion to what the title should be changed to if it really needs to be changed.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to insert a calendar in a cell?

    Previously the title was just "Calendar" but now it is meaningful heading and thats why requested you to changed it.

    Coming to your question, make use of Date Picker which will do the thing which you are expecting to achieve.

    Refer the below thread for more info...

    http://www.excelforum.com/excel-gene...te-picker.html


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to insert a calendar in a cell?

    Oopss... I thought the OP is questioning me so that drafted the Post #4 content by directing it to the OP.

    @ AlKey,

    The first paragraph of Post #4 content is directed to you...

    @ jorgebarata,

    The rest of the content of Post #4 content is for you...

  5. #5
    Registered User
    Join Date
    10-31-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: How to insert a calendar in a cell?

    Thank you very much .

    Best regards, Jorge.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to insert a calendar in a cell?

    Glad it helps you and thanks for the feedback

+ 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. Calendar functions - linking work activities with formatted dates to calendar
    By SKSS in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2012, 06:38 PM
  2. Calendar VBA auto filling week and month based on calendar entry.
    By perrymagic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2011, 02:00 PM
  3. Replies: 0
    Last Post: 10-31-2011, 10:58 PM
  4. Replies: 0
    Last Post: 03-27-2008, 04:36 PM
  5. Modify Yearly Calendar to Monthly Calendar Excel 2000?
    By James Cooper in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-13-2006, 06:50 PM

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