• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

inserting a date control in ms excel cell

aligahk06

Member
Dear All,

How could i select a date picker in ms excel cell .
for ex: in cell C3:C8000 i want a date picker so that i can select particular date and the cell shows the selected date from the date picker.


thanks all for precious time.

rgds,
aligahk06
 
R

Rickbale

Guest
Dear All,

How could i select a date picker in ms excel cell .
for ex: in cell C3:C8000 i want a date picker so that i can select particular date and the cell shows the selected date from the date picker.


thanks all for precious time.

rgds,
aligahk06
Follow these steps

1. Show the Developer tab on the ribbon
The datepicker control belongs to a family of ActiveX controls, which reside on the Developer tab. By default, the Developer tab is hidden in Excel, but you can force it to appear in no time.

Right-click anywhere on the ribbon, and then click Customize the Ribbon…
In the right-hand part of the window, select Main Tabs (usually it is selected by default), check the Developer box, and click OK.

2. Insert a calendar control
A drop-down calendar in Excel is technically called Microsoft Date and Time Picker Control. To insert it in your sheet, just do the following:

Go to the Developer tab > Controls group, click Insert, and then click the More Controls button under ActiveX Controls.
To insert a calendar, click the More Controls button under ActiveX Controls.
In the More Controls dialog window, find the Microsoft Date and Time Picker Control 6.0 (SP6), select it, and click OK.
Select Microsoft Date and Time Picker Control
If you cannot find the Date and Time Picker Control in the list, please follow these instructions to register it.

Finally, click on a cell where you want to insert the calendar control.
That's it! A drop-down calendar control is inserted in your Excel sheet:
The date picker control is inserted in Excel.

As soon as the date picker control is inserted, the EMBED formula appears in the formula bar. It informs Excel what type of control is embedded in the sheet, and in no case you should change or delete it, because this would result in the "Reference is not valid" error.

Inserting any ActiveX control (including DTPiker) automatically turns the Design Mode on allowing you to modify the appearance and properties of the newly added control. The most obvious changes that you will want to make most of the time is to resize your calendar control and link it to a specific cell.

To activate your Excel drop down calendar, go to the Design tab > Controls group, and turn off the Design Mode:
To activate a drop down calendar, turn off the Design Mode.

And now, you can click on the dropdown arrow to display the calendar and select the desired date

Regards,
Rick bale
 
Top