sponsored ads

how to insert drop box calendar in excel 2010

sponsored ads

I want to insert drop box calendar in excel 2010. Please tell me the detailed steps! Thanks in advance!

Asked Oct, 21 2010 Edited by Cooper Oct, 21 2010
add commentflag 

sponsored ads

answer this question

Calendar control (mscal.ocx) was a Microsoft Access feature that could be used in Access worksheets. Calendar control is removed in Access 2010 and is not usable for Excel 2010. Instead, you can use Date Picker or their own custom calendar controls.

Answered Aug, 19 2010
vote up 0 vote down

On the Developer tab use Insert > ActiveX Controls….More controls.
Select the control in the list and press OK
Click on a cell on your worksheet.
Press the "Design Mode" button next to the "Insert button" to turn of Design Mode.

To display the Developer tab in Excel 2007 go to Office Button >Excel Options...Popular
In Excel 2010 : File>Options..Customize Ribbon, check Developer in the Main Tabs list on the right. Answered Nov, 27 2010
vote up 0 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

Desktop Calendar 0.44

Last Updated: Dec 8, 2010
License: Freeware
Filesize: 2.09MB

Continue to downloadPower by Afreecodec.com