Results 1 to 6 of 6

Thread: Excel 2013 - Calendar Pop out when cell clicked

  1. #1

    Angry Excel 2013 - Calendar Pop out when cell clicked



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Help! I've tried everything! So many methods and tutorials and nothing seems to be working! I'm using Excel 2013 which I have a feeling may be the problem - although I am very unexperienced at Excel.

    I'm looking to have a calendar pop out (monthly view is fine) so the user can be prompted to choose a date when they click on a cell.

    I've tried the developer tab>insert>more controls>Microsoft Outlook Date Control>..and then dragging a square, and I get an error saying "Cannot insert object"

    I'm stumped! please help! thanks!

  2. #2
    Acolyte Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    93
    Articles
    0
    Excel Version
    2013, 2016, O365
    This is the most elegant approach I've run across:
    Since I'm too new to the forum, I can't post an actual hyperlink...yet.
    Hopefully, you can easily decipher this:
    http: // www DOT myonlinetraininghub DOT com/Excel-date-picker

    Does that help?
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  3. #3
    Acolyte Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    93
    Articles
    0
    Excel Version
    2013, 2016, O365
    Now that I have 5 posts...
    Here's the actual link:

    Excel Date Picker • My Online Training Hub
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by michellef View Post
    I'm looking to have a calendar pop out (monthly view is fine) so the user can be prompted to choose a date when they click on a cell.
    Please, see you here example
    If you need install Microsoft Date&Time Picker Control 6.0
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Could also have a look at
    http://stackoverflow.com/questions/1...textbox-in-vba

    I like the Trevor Eyre version.

  6. #6
    Seeker potap's Avatar
    Join Date
    Apr 2016
    Location
    Quebec, Canada
    Posts
    6
    Articles
    0
    Microsoft Date&Time Picker Control 6.0 doesn't always work as expected... I have lot of display problems with Excel 2010.

Tags for this Thread

Posting Permissions

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