Share via

Excel 2016 Data and time picker - help!!!

Anonymous
2015-10-30T14:38:27+00:00

I have used data and time pickers before in older excel files....

Now using 2016 and can't find any help in how to install nor use etc...

I have followed various blogs re mscomct2.ocx command prompt instructions BUT no luck...

All I want is for a calendar to appear when I go into a specific cell (column) within excel...

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-10-30T16:53:29+00:00

My hunch is that you installed the 64 bit version of Office, in which (32 bit) activeX controls do not work.

You can get a version that is independent of bitness here: https://sites.google.com/site/e90e50/calendar-control-class

Also, I have built an all VBA treeview control in a similar fashion: http://www.jkp-ads.com/articles/treeview.asp

Was this answer helpful?

70+ people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-10-17T19:25:39+00:00

    I used above link: https://sites.google.com/site/e90e50/calendar-control-class

    It works great.     I even use it in VBA form.   I used: combox to put the date and catch its DropButtonClick event to show up the DatePicker.  I use StartUpPosition, Top and Left to control it is display location.

    Was this answer helpful?

    0 comments