Hello Mr., I had tried with your video instruction but with my machine still not working with these, so do you have any instruction for add date and time picker into user form?
Hello! I think you might be better off trying an alternative such as these listed at Ron deBruin's site www.rondebruin.nl/win/s8/win003.htm I hope it helps!
Hi, I followed your video step by step. I have Excel 2013 64bit (Windows 8.1) but the installation of the mscomct2.ocx file doesn't change a thing. When I want to add elements, it keeps showing me only some MS Outlook Controls, MS Forms Controls, MS RDP Client Controls and other controls but not the date picker controls. Any tips? Thanks
Hi, before doing all the steps I'd like to know if this would work with a network file. Several users will have to access this master file and type in the data including date/time values. Must I install the controls in each PC?
Hi again. I have added only two controls on a userform. Monthview1 and commandbutton1. Default visible value of monthview1 is set to false. On commandbutton1 click event, i wrote monthview.visible = true But it is not showing monthview1, to check i set the default value of monthview1 to true then it shows when form shows. is there anything i am missing? Please advise.
Asslam-oAlaikum Sir please tell me that how can paste MSCOMCT2.ocx in destination folder without any Destination Access Denied Problem. (Please complete this work by Excel VBA)
Question: How can I get my date time picker to work when I am in edit mode (following your addmode and editmode from your other Excel VBA Forms vidoes)? It seems that the DTPicker doesn't want to read into it dates that are already in my worksheet. Any help would be most appreciated. Thankyou
see I don't have any code in my datetime picker- or else i would show you. I thought it would just read and creat new dates. It creates dates just fine it's just when I am in edit mode it would navigate through my already existing dates. But anyway- thank you so much for your help :) These videos are very helpful!
I'm using Office 365 x64 and Windows 64x. Following your video I managed to download, install and register. BUT I can't find the 'Microsoft Date and Time Controll' in 'Additional Controls' Can you please explain that? Thanks in advance Regards from Sweden /Peter
Hi Peter, sadly the Microsoft Date and Time Picker control won't work with a 64 bit edition of Excel. You can find an alternative here sites.google.com/site/e90e50/calendar-control-class I hope that helps!
dear Andrew good morning. i hope you are safe. i have strictly followed your tutorial. once i have successfully registered add in file (mscomct2.....), after inserting a userform i see the picker in the toolbox but when i try to draw a date picker inside the userfom a message pops up saying "user is not allowed to perform specified action". i think there is something to change in security and trust settings. i have vba version 7.0. thanks in advance
hurray, got solved by myself: this is to share my solutions with other who may incur in the sanme: got to excel options - > trust center -> trust center settings -> activex settings -> then tick the fourth option "enable all controls without restrictions and without prompiting (.........etc....). i hope it may help someone
if you find errors code 0x8002801c you must copy MSCOMCT2.OCX in both folder: system32 and syswow64. then go to cmd, must run as administrator then type regsvr32 MSCOMCT2.OCX
Brilliant, and brilliantly simple in the presentation. This was one of the single most helpful computer "how-to" videos that I've ever seen. Thanks!
Thanks a lot Boy, I thought It was really hard. It helped me pretty much. I wish you all the best!
Thanks Alberto, happy to hear that it helped!
Thank you so much. I gave up finding the answer for this problem in the past and now you showed me a way to deal with it.
Enjoyed that, been looking for the date picker for a while now thanks for sharing
It is Very Useful and effective
Man, God bless you...
Dunno what to say else
Thank you George!
As usual, great video. But I still can't download the MSCOMCT2 file, could you give me the link ? that will more great
Hello Mr., I had tried with your video instruction but with my machine still not working with these, so do you have any instruction for add date and time picker into user form?
Hello! I think you might be better off trying an alternative such as these listed at Ron deBruin's site www.rondebruin.nl/win/s8/win003.htm
I hope it helps!
Hi, I used these controls. However, obviously nobody else can use the monthview, only me. Is there a solution to this problem? Thanks
Hi, I followed your video step by step. I have Excel 2013 64bit (Windows 8.1) but the installation of the mscomct2.ocx file doesn't change a thing. When I want to add elements, it keeps showing me only some MS Outlook Controls, MS Forms Controls, MS RDP Client Controls and other controls but not the date picker controls. Any tips? Thanks
Damn, thanks for your reaction. Hope someone could come with a workaround for the 64bit version.
Hi, before doing all the steps I'd like to know if this would work with a network file. Several users will have to access this master file and type in the data including date/time values. Must I install the controls in each PC?
Thank you for this video. It would be great if you make another video for list view control.
Hi im unable to find it in additional tools despite it being successfully added via cmd do help me!
Awesome - how do I align the text in the datepicker to show in the middle as there is no centre align property?
How I can put password expiry time in userform by vba code in excel
Hi sir, when i was registered MScomct2.OCX file. The error Code shows " 0x 8002801c. Please help me.
great video, thank a lot
You're welcome, Diego! Thank you for watching!
many thank.. u solve my problem
Hi again. I have added only two controls on a userform. Monthview1 and commandbutton1.
Default visible value of monthview1 is set to false. On commandbutton1 click event, i wrote monthview.visible = true
But it is not showing monthview1, to check i set the default value of monthview1 to true then it shows when form shows.
is there anything i am missing?
Please advise.
Hi, you could try applying the Repaint method to the form
Me.Repaint
Or perhaps apply the Refresh method to the month view control.
I hope it helps!
Asslam-oAlaikum Sir please tell me that how can paste MSCOMCT2.ocx in destination folder without any Destination Access Denied Problem. (Please complete this work by Excel VBA)
Awesome , Awesome , Awesome
thanks...help me alot..
AWESOM!!!!! Thanks a lot!!
Question: How can I get my date time picker to work when I am in edit mode (following your addmode and editmode from your other Excel VBA Forms vidoes)? It seems that the DTPicker doesn't want to read into it dates that are already in my worksheet. Any help would be most appreciated. Thankyou
Could it be that my pre-existing dates are in a different format ??
Example:
pre-existing dates:
1-Mar-18
date time picker is set to:
3/1/2018
see I don't have any code in my datetime picker- or else i would show you. I thought it would just read and creat new dates. It creates dates just fine it's just when I am in edit mode it would navigate through my already existing dates.
But anyway- thank you so much for your help :) These videos are very helpful!
I'm using Office 365 x64 and Windows 64x.
Following your video I managed to download, install and register. BUT I can't find the 'Microsoft Date and Time Controll' in 'Additional Controls'
Can you please explain that?
Thanks in advance
Regards from Sweden
/Peter
Hi Peter, sadly the Microsoft Date and Time Picker control won't work with a 64 bit edition of Excel. You can find an alternative here sites.google.com/site/e90e50/calendar-control-class
I hope that helps!
dear Andrew good morning. i hope you are safe. i have strictly followed your tutorial. once i have successfully registered add in file (mscomct2.....), after inserting a userform i see the picker in the toolbox but when i try to draw a date picker inside the userfom a message pops up saying "user is not allowed to perform specified action". i think there is something to change in security and trust settings. i have vba version 7.0. thanks in advance
hurray, got solved by myself: this is to share my solutions with other who may incur in the sanme: got to excel options - > trust center -> trust center settings -> activex settings -> then tick the fourth option "enable all controls without restrictions and without prompiting (.........etc....). i hope it may help someone
Thank you very much, sir!
WOW WOW WOW !!!! Thank !
You saved me!
hello sir. got a problem here. mine says element not found. can you help me on this? im totally newbie. -_-. thanks.
me also having same pbm in win 7 excel 2013. date picker is not able to dragged down and it shows Element not found
if you find errors code 0x8002801c you must copy MSCOMCT2.OCX in both folder: system32 and syswow64. then go to cmd, must run as administrator then type regsvr32 MSCOMCT2.OCX
WHY just WHY i cant make it work..i did step by step...i got the confirmation pop up and i cant find that stupid date and time...WTF is going on
Thank you.
Super!, muchismas gracias, realmente me sirvió.
thank you
great explanation as always, but anyone else finds the process absolutely ridiculous?
Did not work for me at all
dont work
Thank very much
You're very welcome, thanks for watching!
Thank you