New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
How to activate datetime picker in 2007
3 posts
• Page 1 of 1
How to activate datetime picker in 2007
by maramakr » Tue Dec 13, 2011 11:08 pm
I have used datetime picker in excel 2003. When I tried to open the same file in 2007. It is not working. How to activate this in 2007. As I am very new to 2007, if anyone knows to resolve please help me in this regard.
- 0
- maramakr
- Rookie
- Posts: 2
- Joined: Dec 13, 2011
- Reputation: 0
Re: How to activate datetime picker in 2007
by charles » Wed Dec 14, 2011 4:59 pm
Hi,
Welcome to the forum. For the "Calendar". Go to "Developer" select "Insert" then you select "Additional" controls. This will be in the lower right conner. When you click it this will proved a list of controls. You will select "Calendar Control 11".
Then when you click on a cell it will place the Calendar for use.
Hope this helps.
Welcome to the forum. For the "Calendar". Go to "Developer" select "Insert" then you select "Additional" controls. This will be in the lower right conner. When you click it this will proved a list of controls. You will select "Calendar Control 11".
Then when you click on a cell it will place the Calendar for use.
Hope this helps.
- 0
There are other ways too do this but...
Be kind let us know if you posted somewhere else!
Charles
Be kind let us know if you posted somewhere else!
Charles
- charles
- Excel Badass
- Posts: 632
- Joined: Dec 10, 2011
- Location: Mississippi
- Reputation: 1
- Excel Version: Excel 2003, 2007 and Mac 2011
Re: How to activate datetime picker in 2007
by maramakr » Tue Dec 20, 2011 1:03 am
Thaks for the great help.
- 0
- maramakr
- Rookie
- Posts: 2
- Joined: Dec 13, 2011
- Reputation: 0
3 posts
• Page 1 of 1
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 227 guests