"DTPicker" (Date and Time Picker) missing after upgrading to Office 365...

Hey all,

When running my VBA excel program, the DTPicker box that I have on my Userform for users to easily select a date is throwing an "object not found" type error.

I've had this problem before on individual machines running earlier versions of excel (2013, 2016) but was remedied by registering the activeX file MSCOMCT2.ocx in either the System32 or Syswow64 folders in the C:\windows directory.

All the pc's that run this file have the OCX file registered and are getting the same error.

In VBA developer, the userform toolbox shows the icon where the DTPicker should be, but is blanked out of sorts. See below (circled in red):

Pq4qLmP.png


Perhaps I'm missing something simple, as I wouldn't be surprised. I created this program awhile back and don't use VBA often at all.

Any help would be fantastic!

Interesting. Thought I had it running on 64 bit installs. Or at least the operating systems were 64 bit.

Is there not a Microsoft solution to this? How can something seemingly so simple be such a nuisance? Or perhaps it isn't so simple...

Originally Posted by CK76

Hmm, I've never tested. but try posting from Surendar Kani & Ashidacchi in below link.
https://social.technet.microsoft.com...eitproprevious

Personally I dislike DTpicker as it requires end user to install the control.

yes, that's the procedure that I've used in the past on machines where it didn't work, as described in my original post.


That other date and time picker you shared is cool, but it's an entire form vs just a combo/list box that the DTPicker is. I guess I can call it somehow with a event trigger on my userform.

Hmm, there are other options. See link, Ron lists his own as well as several other calendar tools.
https://www.rondebruin.nl/win/s8/win003.htm

I realize that this reply by CK76 was from 2015, and I have tried to retrieve the excel-datepicker from the link above. I even created an account on the backblazeb2.com account, but when I tried to retrieve it, I get the message: "code": "account_trouble",
"message": "Account trouble. Please log into your b2 account at www.backblaze.com.",
"status": 403 ..... ? Does anyone have access to this download that I could get in some way?

if you are still stuck here are a couple of alternatives - one is set-up to place dates in columns A & B - the other uses a UserForm textbox to receive the date.
The code pointing the calendar output to its destination is in the btnClass module.
torachan.

Thank you torachan.