+ Reply to Thread
Results 1 to 4 of 4

How to Pop-up Calendar in any cell. My excel is 2016 and my System is a x64-Based PC

  1. #1
    Registered User
    Join Date
    04-12-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    13

    How to Pop-up Calendar in any cell. My excel is 2016 and my System is a x64-Based PC

    Hello dear profesionals.
    I would like to have the funtion to click in a specific cell in excell and a calendar pop-up. My excel is 2016 and my system type is a x64-Bsed PC.
    I am trying to have a calendar pop-up when I click in a specific cell in my excell spreadsheet. I have two cells, on for DATE in B4 (where I want to add the option to click in that cell and a calendar pup-up). And another cell (D4) with time and I would like to have the option to set-up a time as well. See my attachment in case you want to see the form.

    Thanks for your contribution to this wonderful forum. I hope to hear from you soon.
    Juan
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: How to Pop-up Calendar in any cell. My excel is 2016 and my System is a x64-Based PC

    Juan,
    I have added a pop up calendar to your file. If you double click on the cell you wish to put in the date, it will pop up. I don't currently have a time pop up for you but will see what I can do later. No time (no pun intended) now.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-12-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    13

    Re: How to Pop-up Calendar in any cell. My excel is 2016 and my System is a x64-Based PC

    Hi Alan, Thank you very much, but when I try to add the code to my file it does not work. I really would rather to learn how to do it and I will apply the learning lesson in any other spreadsheet. Let say, if I would like to pup-up a calendar in a B6 cell, How could I do it for this specific Cell (B6)?

    Thanks for you time Alana on this. I hope you could help me on this.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: How to Pop-up Calendar in any cell. My excel is 2016 and my System is a x64-Based PC

    Using the code I provided, If you double click on cell B6, then the calendar form will appear and you select the date.

    If you wish to put this in another file, copy the form and place it in the file you wish in the VBE, ie insert Form. Then copy the code provided as shown in the VBE in the file I uploaded.

+ 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. Excel 2016 Userform with pop up calendar
    By mcvideo in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 03-31-2018, 02:39 PM
  2. Replies: 1
    Last Post: 10-17-2017, 10:36 PM
  3. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. troubles with running a plug-in in excel 2016 on a 64 bit system (mac)
    By samsonicx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2016, 03:28 AM
  5. Excel 2016 Web Based
    By rousseauassociates in forum Excel General
    Replies: 2
    Last Post: 03-23-2016, 01:53 AM
  6. [SOLVED] 2016 calendar - A column
    By noddyneil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2015, 02:07 AM
  7. Is Excel's built in calendar/date/time system useful??
    By MrShorty in forum Excel General
    Replies: 9
    Last Post: 10-24-2014, 02:00 AM

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