?
Solved

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

Posted on 2005-03-08
1
Medium Priority
?
2,590 Views
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?
0
Comment
Question by:whart91426
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 81

Accepted Solution

by:
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.

Cheers!
Brad
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
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…
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…

770 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