Date picker in Excel userform with date and time.

Question

Is it possible to get the calendar control, the date picker, with the time as shown in the picture? This screen shoot is not from userform in excel, rather another application I do not know its language.

Answer 1

It looks like the MS Date & Time Picker control.

You can add this by right clicking on the Toolbox then selecting "Additional Controls" scroll way down and look for the Microsoft Data and Time Picker. Select the Check Box by this and it is added to the Toolbox. You can then add this to your form.

---

Brian, ProcessIT- Hawke's Bay, New Zealand

Answer 2

Hello Brian, I know how to insert DTPicker, but the question is how to get the "Time" together with the date.

Answer 3

Sorry that was not clear.

Right click on the Control, Choose Properties.

Set the Format to 3-dtp Custom

Then set the Custom Format to the format you need:

eg: dd/mm/yyyy hh:mm.s

---

Brian, ProcessIT- Hawke's Bay, New Zealand

Answer 4

Hello Brian, the result is always is 26/00/2013 12:00:00 ?

Answer 5

The custom format should be:

dd.MM.yyyy hh:mm

Answer 6

Re:  Date Picker for Excel

I just modified the free excel Date Picker Add-in of mine to include time with the current date.
(date & time is shown in the formula bar - date is shown in the cell - change the cell format to include the time in the cell)

After installing as an add-in, right-click any cell to choose the Date Picker item on the popup menu.
No ads, no cookies, no trackers, no registration & 10,000+ downloads.

https://goo.gl/IUQUN2 (Dropbox)

'---

Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 7

Thanks James, this was helpful. 

Answer 8

hi Brian,  can the date/time picker tool be added to the 'additional controls' group?   It doesnt appear as available when I go to 'additional controls'.   Thanks!

Answer 9

This is a very old thread now!

The Date Time Picker control is an old 32 bit control in the file MSComCtl2.ocx.

You will need to locate and register this ActiveX to add it to a user form. It used to be included with Office but not i'm sure if it still is?

It will only work if you use Excel 32 bit as MS did not release a  64 bit version.

---

Brian, ProcessIT- Hawke`s Bay, New Zealand