Infamous Date Picker does not work anymore

Hello everyone,

Before i transferred to office 365 for business, i had simple office 365 and date picker controls that i had in my userforms were working just fine. Now they are not, and giving me the message - "Objects could not load because they are missing on this machine".

I searched through various solutions and one of them was to update mscomctl.ocx file to proper version, but mine already is.
Capture.JPG

Is there any other way to fix this and get the date picker back?

Or, are there decent alternatives that would do the same thing, that would enter a date in the textbox on the userform?

Thanks.

hello, i use this calendar form that u can use as data picker.

See for yourself.

https://trevoreyre.com/portfolio/excel-datepicker/

best Regards

Thank you so much!

This seem almost work.

What I am trying to do is, call the calendar form from my other form via command button, select date, and copy date into my textbox on the userform via okay button. But, i am running into the issue, that calendar also closes my other userform, even though I had replaced "Unload Me" with "Unload formCalendar".

Any ideas here?

Thanks

this issue is really frustrating, no matter what I do, upon closing calendar, or just hiding it, another form closes too.

Other then that it works, but this issue kills its usability.

Any way to keep that other form open?

I'm not at home atm. I can help you tomorrow.

But if you press OK in the calendar for it should close the calendar and keep the userform open. U don't need unload calendarform

I was able to figure out the intricacies of this calendar form. Almost.
Now I would like it to pop up in the center of the screen instead of wherever. But, I am sure I will find out how on my own.

Thank you so much!

Originally Posted by Sergey1989

I was able to figure out the intricacies of this calendar form. Almost.
Now I would like it to pop up in the center of the screen instead of wherever. But, I am sure I will find out how on my own.

Thank you so much!

Glad I could help.

Thank you! This works wonderfully!

Dont really want to start another topic, has anyone ever built a standalone num pad for ease of entering phone numbers?

see attached. Adapted from
https://www.experts-exchange.com/que...-userform.html

Many thanks!