Solved

Excel 2007 date picker

Posted on 2009-07-16
8
1,584 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
  • 4
  • 3
8 Comments
 
LVL 20

Assisted Solution

by:pari123
pari123 earned 150 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 350 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
 

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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now