Date and Time Picker-Excel 2016

[Bill1234]

Hi,

I am having trouble figuring out how to get the date and time picker for userforms. I have Excel 2016. Any suggestions?

Thanks.

[harrisonland]

Ah... the age-old date picker problem. MS, as far as I know, still haven't come up with one.

In the past I've used this on here: https://trevoreyre.com/portfolio/excel-datepicker. It seems to work well for dates.

I haven't looked into a time picker.

Tim

[torachan]

Frustrated over the years, I have tried most approaches.
Attached a couple if they are of interest.
with the 'time picker' click on hour or minute numerals, they highlight light blue, set with scroll button.
The 'datepicker' is just three comboboxes for selection.
Both can be activated by clicking in column 'A' (A2 and below)

[Bill1234]

Thanks for the help!

[torachan]

Another DatePicker, click in column 'A' (A2 downwards)
the scroll button acts on the blue highlighted box.
click on day or month or year boxes to highlight.