Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Can I insert a drop down calendar and time clock in excel?

Posted on 2005-03-08
Medium Priority
Last Modified: 2012-06-21
I know how to use validation but want to know if I can have something similar to a calendar that I can just click on a date and time?
Question by:whart91426
1 Comment
LVL 81

Accepted Solution

byundt earned 500 total points
ID: 13487640
Hi whart91426,
There is a calendar controls in my Excel 2003. To install it, display the Controls ToolBox toolbar (using the View...Toolbars menu item). Click the "More controls icon" and select "Calendar Control 9.0". You can then click and drag on the worksheet to draw the boundaries of the control. If you right-click the control and choose "Properties", you can link it to a worksheet cell using the Linked cell property.

I did not see a way to make the control into a dropdown, nor did I see a time control.


Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
Tech giants such as Amazon and Google have sold Alexa and Echo to such an extent that they have become household names. And soon they are expected to be used by commoners in their homes, ordering takeout, picking out a song, answering trivia questio…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question