?
Solved

Excel 2007 date picker

Posted on 2009-07-16
8
Medium Priority
?
1,597 Views
Last Modified: 2013-11-30
Hi, i have an 2007 excel file (attached) and i need to insert some sort of function that will allow me to choose a date that will then be automatically entered into the field. (please see the attached file for correct format of date and time)

Is this possible to achieve. Can anyone help me with this please, thanks in advance
checklist.xlsx
0
Comment
Question by:oo7ml
[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
  • 4
  • 3
8 Comments
 
LVL 20

Assisted Solution

by:Ardhendu Sarangi
Ardhendu Sarangi earned 600 total points
ID: 24870950
Hi,
Check out these excellent solutions in EE.

http:Q_23487712.html
http:Q_22863212.html

- Ardhendu
0
 
LVL 39

Accepted Solution

by:
nutsch earned 1400 total points
ID: 24870989
Here is your file updated with the calendar control and some code to make it appear / disappear and fill in your cell.

Thomas

PS EE doesn't allow xlsm so please overwrite the extension from xlsx to xlsm

24576202.xlsx
0
 
LVL 39

Expert Comment

by:nutsch
ID: 24871141
Actually, the Microsoft  date time picker control is a better choice for you. Check out the attached file, which should also be renamed to xlsm.

Thomas

24576202.xlsx
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:oo7ml
ID: 24873026
Hi, thanks for your reply.

I have download the file, renamed it to xlsm and accepted the macro.

When it opens there is 2 red X's across both of the date and time boxes... am i doing something wrong, thanks again for your help
0
 
LVL 39

Expert Comment

by:nutsch
ID: 24873254
You haven't enabled activex controls, which is what the date and time picker is. Check the following link to see how to do it and what it entails:

http://office.microsoft.com/en-us/excel/HA100310671033.aspx

Thomas
0
 

Author Comment

by:oo7ml
ID: 24873665
So, does this means that anyone who wants to use it has to enable active x controls
0
 
LVL 39

Expert Comment

by:nutsch
ID: 24873718
Yes, but you could put a macro that hides the control if they're not enabled. You wouldn't have the calendar, but you could enter the data manually.
0
 

Author Comment

by:oo7ml
ID: 24874241
Ok thanks, i will try that out first, thanks again
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

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