Date Picker Control - Excel VBA Data Entry Userform (Part 4)[32bit only]

[@TheEngineeringToolboxChannel]

***TROUBLE SHOOTING SUGGESTIONS*** Note: It seems as though this ocx file will only work with 32bit versions of Excel. It will work on both 32 & 64 bit machines but only 32 bit office apps. 1. Re-watch video and follow steps exactly. 2. Make sure you are opening the command prompt as administrator (right click>run as administrator) [ 2:15 ] 3. Verify the 'regsvr32 command and file path you are using are entered correctly. [ 2:22 ] 4. If you pasted the file path of the ocx file into the command prompt, make sure a "[?]" symbol did not appear in front of the path. If it did make sure to delete. [ 2:53 ] 5. Verify your command prompt active directory is set to "C:/Widows/System32" before running code (if not enter command 'cd C:/Widows/System32' and hit enter to change the working directory. Then run regsvr32 command. Note: Your file path may differ so verify this as well. 6. Try using 'regsvr32.exe' followed by the file path instead of just regsvr32. 7. Whether you are on a 64bit or 32bit machine, make sure to paste the files to the "SysWoW64" folder as I did. [ 1:40 ] 8. Try running the regsvr32 command with an active directory of "C:/Widows/SysWow64". Enter 'cd C:/Widows/SysWow64' to change the active directory. Then run the regsvr32 command with the location of your ocx file.

[@DubaiRaja]

I did the same but still it is not showing in vba please suggest

[@TheEngineeringToolboxChannel]

Are you using 32 or 64 bit Excel?

[@DubaiRaja]

@@TheEngineeringToolboxChannel 64 bit

[@TheEngineeringToolboxChannel]

Selvin Raja see the first sentence of the trouble shooting tips.

[@stefanogattoCH]

Given most of the people use 64 bit version of Excel, maybe the best would be to notify in the title of this video that it's for Excel 32bits only. I spent precious minutes to find out, so writing it in the tile would help! Something like "Date Picker Control - Excel/32 bit ONLY! - VBA Data Entry Userform"

[@mustafapatel3331]

Finally!!! Thankfully this worked for me unlike other long videos with nothing🥳

[@azorjistephen9707]

This was really Helpful. Thanks

[@SwissMarkus]

excellent tutorial exactly what I have been looking for .. thank you for your effort👍👌

[@hatranthanh3813]

Many thanks from VN

[@jjoel3]

Great job!!! Fixed an Issue been dealing with for two weeks!!!

[@TheEngineeringToolboxChannel]

Joel Lengyel awesome! Glad I could help 👍

[@joanmontana8359]

Nprjoan thanks for the calendar control

[@sonigajanand]

Great sir

[@eggchipsnbeans]

Thank you, worked nicely

[@kalite02]

very useful.. many thanks

[@FrancisAAfful]

for those having error with opening additional controls window, kindly change your excel combability to windows XP service pack 3.

[@TheEngineeringToolboxChannel]

Awesome thanks!

[@edwinosagiede2328]

Great work. It worked for me.

[@TheEngineeringToolboxChannel]

Awesome! Glad to hear it!

[@piseyleang422]

I already registered successfully, but still i cannot see the DTPicker in my toolbox. Any advice?

[@TheEngineeringToolboxChannel]

You are likely running 64bit excel. This control only works on 32bit unfortunately.

[@abbasnoufal9225]

Ty so much for the easy Tutorial love it and u earn my sub

[@TheEngineeringToolboxChannel]

Awesome glad you liked it!

[@tylernichol6422]

Very cool, thanks!

[@suhasdeore3288]

Thaks buddy its working

[@tiroliroprou]

Hi, I did all the steps the video said, but when I try to add an additional control in my toolbox, the Microsoft date and time date picker control doesn't appears. Does anybody know why? PD. I already registered on cmd prompt the instruction thks

[@TheEngineeringToolboxChannel]

Check pinned comment trouble shooting tips. Most common issue is that this does not work on 64 bit versions of excel

[@aga5187]

Thank you good man. Very greaat!!!

[@aatishagarwal29]

Thanks. It was so easy :)

[@erkanbey787]

thanks for sharing but please put a note above as it doesn`t work with 64..Worked on that file several times with no luck...Then read the comments :)

[@llobj001]

Can you do a video using VBA showing: 1) how to extract Global Address List GAL details from Outlook including user name into excel 2) how to cut and pasting details from Excell into Project (more efficient method than a loop etc) 3) how to use Excell data to write rules into outlook to auto sort emails (i.e. if you have a project number in excel, use that to write a rule that sorts emails if this number is found in the subject title and also ask if you want to assign a project number to an email before sending. 4) how to write a user form in word that will allow you to add new custom 'fields', insert them as you type and update them from the user form (accessible via its own ribbon icon). These features would be cool to see them working if you could build that functionality from an excel project spreadsheet. My challenge to you!

[@TheEngineeringToolboxChannel]

This sounds like a challenge indeed...I would definitely need some time to look into this but I think it would be doable. I haven’t used VBA much for outlook or project.

[@dipankarroy5529]

Sir, I am using MS Office 2016 now.but the problem is that there is no Listview & Date picker option in the userform. I got Mscomtct2.ocx and Mscomctl from internet. I downloaded and installed the ocx file, after that there is Listview and Date picker file missing. how to solve ?

[@TheEngineeringToolboxChannel]

Problem is likely that you are running a 64 bit version of excel. Unfortunately these controls are only available for 32bit versions.

[@Sparqcorporatetraining]

Everything seems to work fine but when I go to activate it in the Toolbox, it's not there. I'm using 64 bit Excel. Is that the reason? You don't indicate that it only works in 32 bit Excel. What is the advantage / disadvantage of using 64 bit Excel and should I switch to 32 bit Office in order to do this? I hope not. Let me know? Thanks for your excellent instructions.

[@disise5781]

I have had the same issue

[@danhiggins1427]

Same here. Everything seemed to work except it is not appearing in the additional controls

[@nizarelaouina1790]

@@danhiggins1427 same here

[@rubinator2000able]

followed all the steps and it seemed to be working but the last step is not, its not in the additional controlls, any clue?

[@TheEngineeringToolboxChannel]

Did you check the pinned comment with trouble shooting tips?

[@rubinator2000able]

@@TheEngineeringToolboxChannel yes

[@TheEngineeringToolboxChannel]

@@rubinator2000able are you using 32 or 64 bit excel?

[@rubinator2000able]

@@TheEngineeringToolboxChannel just fixed it, turned out i was doing these steps with a file called mscomctL.ocx istead of mscomct2.ocx. thanks for your help dude, works like a charm

[@TheEngineeringToolboxChannel]

Awesome. Glad it worked out

[@MrVigneshwaran44]

Thank you

[@TheEngineeringToolboxChannel]

No problem! Hope it was helpful. 👍

[@vivekcardssambalpur3152]

Thank you for helping

[@TheEngineeringToolboxChannel]

Thank you for watching! 😀

[@attilatoth1522]

Thanks a lot, save me lots of time (Y)

[@justcallmekrishmusic]

Will this work if the workbook is then used on a different pc which doesnt have the ocx file? Thanx

[@TheEngineeringToolboxChannel]

Unfortunately it will not. The OCX file needs to be on every computer that uses the file.

[@justcallmekrishmusic]

@@TheEngineeringToolboxChannel thank you

[@wayneseymour1]

I did exactly a you instructed it registered but still not showing up in the additional tools list I'm using Windows 10 64 bit Office 2016.

[@TheEngineeringToolboxChannel]

Did you check the trouble shooting list that I pinned above? You may want to try move and register the file in the "system32" folder instead of the "SysWoW64" folder. Especially if you are running a 64bit version of Office. Depending on the version of Excel (32bit vs 64bit) may change where you need to register the file.

[@wayneseymour1]

did as you said even after placing it in the sys32 folder and successfully registering it it still does not show up in the additional tools list.

[@gajanandhumal8883]

@@wayneseymour1 same problem with me. Window 10

[@TheEngineeringToolboxChannel]

@@gajanandhumal8883 It seems to be an issue with 64bit versions of Excel. I am seeing some threads out there that say this will not work on 64bit versions. social.technet.microsoft.com/Forums/en-US/e10f77f6-de14-41d9-971f-07e0ddf528e5/how-to-install-microsoft-date-and-time-picker-control-60-sp6-in-window-8?forum=excel The only thing I can suggest is to re-download Excel as a 32 bit version. Sorry about this! I did not realize it before making the video.

[@milovanbusolich6897]

@@gajanandhumal8883 Me too! What a bad shit

[@dipankarroy5529]

Sir, I want to use excel Calendar (no date time picker), but date format is becoming MM/DD/YYYY, I want format DD/MMM/YYYY, for example 21/Mar/2022 and also I want to use the same format in the Listbox1 . How can I do this by Userform in excel. Thank you.

[@TheEngineeringToolboxChannel]

Try something along the lines of Format([date],”DD/MMM/YYYY”)

[@mubasharhill7154]

Hi. i have followed all steps successfully but still unable to see date and time picker into additional controls. Any additional suggestion for MS 2019? Thanks

[@TheEngineeringToolboxChannel]

Did you check the pinned comment with trouble shooting tips?

[@trantuananh1961]

Thank for sharing! I have problem. I made complete excel macro file include Date & time picker inside userform. The file run well on my laptop (Windows x64 based, Office 32-bit). Anyway this file couldn't run on another PC (Windows x64 based, Office 64-bit). Some information I got show that: this Active X does not support to run on my case. Is this true? If not true, please advice me. Thanks in advance!

[@TheEngineeringToolboxChannel]

This is true. This active x control does not run on excel 64 bit

[@roronoazoro8343]

still the date picker wont show in the additional tool list

[@wayneseymour1]

OK I finally got it to load (reverted to office 32bit) and I have the Dtpicker icon on the tool pallet but when I go to use it I get a error "Class Factory Cannot Supply Requested Class". I uninstall it and reinstall it but get the same error. Tried both the System32 and sysWOW64 folders even the System folder with no lick. However I am able to use it on a spread sheet, just not on a user form. all other controls work fine just not the DTPicker or the Month-view controls. My office is up to date (Office2016 32bit on a Windows 10 64 bit machine. Is there a setting in the registry that needs to be changed? I have run out of options and have not found a solution on-line that works.

[@TheEngineeringToolboxChannel]

That is very strange. I have never seen any error like that before. Just shooting in the dark here but try this... 1. Un-register both files using: "regsvr32 /u [File Path]" 2. Re-register just under the SysWoW64 since you are on a 32 bit version now 3. If that doesnt work.. 4. Un-register file again 5. Re-Download excel 32 bit version 6. re-register in SysWoW64

[@bbierman7]

Got it all set up! Curious, now how do I set it to look at my date column on a different tab in the same sheet?

[@TheEngineeringToolboxChannel]

Hey Brendan, not quite sure what you mean. Feel free to email me and we can discuss more. I’d be happy to help. [e-mail]

[@edgeno]

Followed your steps but during registration im having this error message."The module "C:\Windows\SysWOW64\MSCOMCT2.OCX" was loaded but the call to DllRegisterServer failed error code 0x8002801c" please help

[@TheEngineeringToolboxChannel]

Read the pinned comment for trouble shooting tips.

[@spambiengentil]

@@TheEngineeringToolboxChannel We woud like but... where is it pinned ?? Thanks.

[@marcelo687]

@@spambiengentil It's the first comment you can see below the video. Tell me if it worked for you

[@spambiengentil]

@@marcelo687 Now i can see it. Strange, why the other day i can't ? Maybe i must wear goggles ^^ I have Office365 in 64bits so, no solution. Thank you ;-)

[@AamirSaeedTajalli]

hi, how can we set datepicker format DD-MMM-YYYY on run time? Kindly help.

[@vasanthviswa7295]

nice, also is there a way to to select year from list, month from list and finally date?

[@TheEngineeringToolboxChannel]

Vasanth Viswa yes the year is built into the control on the top

[@TheEngineeringToolboxChannel]

Vasanth Viswa sorry I think I misunderstood your question at first. Yes, you can have three combo boxes and then use those values in the dateserial() function to return the date. So yes it’s possible but I’m sure why you would want to do this instead of the date picker control.

[@LamNguyen-WordUnveiled]

I did step by step. But MS Date and time not show in additional control.

[@marcosmjjt]

How Can I use the "change" event each time I change the date? So, I want to do one thing every time the date is update, but I want do this without bottom. My question is if the datetimepicker has events like change or afterupdate

[@TheEngineeringToolboxChannel]

Yes they do. Every editable control should have a change event.

[@marcosmjjt]

The Engineering Toolbox Channel thank you for your reply. I used the change event from combobox but it didn’t work. I can’t find where is the change event of datetimepicker. So, I change the date on form and nothing happen. I must to create a pushbottom to get the date value, but I am trying a way to get the value after change date without any bottom.

[@TheEngineeringToolboxChannel]

@@marcosmjjt open the userform in the VBA editor. Then double click data picker control. This will open the module for the userform. By default it will create a sub for the "callbackkeydown". In the top right of that window, there is a dropdown where you can select the change event. Once selected it will create a sub for the change event. This is where you can add your code. It should say something like "Private Sub DTPicker1_Change()". Be sure this matches the name of the date picker control.

[@adnanalam3751]

Thanks for the video. It's amazing but i just did't get the last part when you rename datepickers. There wasn't any textboxes , are the textboxes are hidden? or how did you have datepicker and textbox with the same name? and my datepickers do not get connected to textboxes. kindly consider it. Thanks alot

[@TheEngineeringToolboxChannel]

Remember this was the third video in a series. If you go back and watch the previous videos it may make more sense.

[@sajidakram7812]

hi great videos where is the vba coding that allows you to put the date onto a cell in the worksheet

[@TheEngineeringToolboxChannel]

Watch the previous videos in the series

[@sajidakram7812]

That’s what I tried to search for but cannot find in your uploads Please advise

[@sajidakram7812]

The Engineering Toolbox Channel I can’t find the video can you please send me the link

[@TheEngineeringToolboxChannel]

kzbin.info/www/bejne/bXrEg2WmqJ19hJY start with this. Let me know if you have questions. Sorry for the bad quality it is an old video

[@sajidakram7812]

@@TheEngineeringToolboxChannel hi i have watched all 4 videos but in the video you do not go into how the date picker code shoild be written can you please send me the code allowing you to enter a date inside userform and transfering it onto a worksheet please.

[@aadityarajshinde3469]

Can you please suggest some alternative for MS Office 64-bit version?

[@TheEngineeringToolboxChannel]

MS office 32bit is what you need to do this.

[@johnjavier19]

will it still work if i transfer the excel file to other pc?

[@TheEngineeringToolboxChannel]

Good question! The OCX file will need to be downloaded and registered on all machines using the workbook. However, this control was included with versions prior to Excel 13 (i believe) so if they are on an older version they may not need to download and register the ocx file.

[@BarbHendersonconsulting]

It seems to work fine when I install it on my user form, but when I click somewhere else on the form it disappears. All the other controls are working fine, I am confused

[@TheEngineeringToolboxChannel]

Hmm. Hard to say what the issue is without seeing it. Feel free to email me screenshots of your issue at [e-mail]. Id be happy to help!

how to solve this "ClassFactory cannot supply requested Class" after I add this date picker

[@bayanbiri3362]

thanks , perfect

[@asaadh183]

hey, i did everything u said, it got registered but the control still does not show up. can you help me?

[@TheEngineeringToolboxChannel]

Did you read the pinned comment with trouble shooting suggestions?

[@tulasharma2434]

not work...i have try many time but no option showing

[@TheEngineeringToolboxChannel]

Tula Sharma did you read the pinned comment with trouble shooting suggestions? Remember this will not work if you are on 64bit excel.

[@naratsu05]

do u have for list view?

[@AweshBhornya-ExcelforNewbies]

This is the error i received while running this command in command prompt 'regsevr' is not recognized as an internal or external command, operable program or batch file.

[@TheEngineeringToolboxChannel]

“Regsvr32” not regsevr

[@AweshBhornya-ExcelforNewbies]

@@TheEngineeringToolboxChannel I checked it and managed to run it successfully and even after restarting the pc it is not showing up in additional controls

[@mariuspetrucristea1686]

is it possible to pickup ina cell data and in another one the time?

[@TheEngineeringToolboxChannel]

Yes, this is possible. Please email me if you would like to discuss further. [e-mail]

[@bharatgulyani124]

Great!!

[@user-Agri-TEC]

what is that CMD command? is it "regswe32"

[@TheEngineeringToolboxChannel]

regsvr32

[@vinaynimje97]

I m using date picker in userform but only two digit of date is saving in Sheet1

[@TheEngineeringToolboxChannel]

vinay nimje hmm that’s strange it’s very hard to say what the issue is without see the workbook. Feel free to email me on this. [e-mail]

[@vinaynimje97]

@@TheEngineeringToolboxChannel problem sloved.... I was using dtpicker.text instead I should used dtpicker1.value..... I have another question for you ... How can add search update value through userform to another workbook sheet in Excel or if I want to add update value in access

[@TheEngineeringToolboxChannel]

vinay nimje thanks for the question. Again it is best if I can see what you are trying to in this case. Feel free contact me and discuss via email.

[@contrasteseirl2671]

Please, It works for Excel 2013, w7 64 bits?

[@TheEngineeringToolboxChannel]

Thanks for the questions. See the pinned comment with trouble shooting suggestions. This will work with a 64bit computer but only if you have a 32bit version of excel downloaded.

[@mahbub-e-ilahi5953]

hi, how to add date picker tool in office 365, because date picker tool of office 2016 is not working in office 365

[@TheEngineeringToolboxChannel]

Your issue is more than likely related to the bit version of 365 you are using. Check if you are using 64 bit excel.

[@babyfaseena5504]

does this require any specific coding in vba?

[@TheEngineeringToolboxChannel]

Baby Faseena what you saw in this video is all that is required to use a date picker control.

[@fabricioribeiro3682]

Man, it isn't working on office 365. Please, could someone help me? I did rigister succefully the "MSCOMCT2.OCX" file, but even so it didn't work for me. The control do not show up on additional controls tab. What must I do?

[@TheEngineeringToolboxChannel]

Did you read the pinned comment that says trouble shooting suggestions?

[@Radik71101]

Спасибо

[@TheEngineeringToolboxChannel]

с удовольствием

[@ferdinandogiordano2195]

How can I set up a datepicker with the date of another datapicker from another sheet?

[@TheEngineeringToolboxChannel]

Update the other one with the value of the first date picker during the change event.

[@nrups9849]

Can anyone tell me if I include the date picker in my workbook does it work if I send the file to another colleague who has not downloaded the file?

[@TheEngineeringToolboxChannel]

This will not work l unless your colleague also has the date picker file installed.

[@nrups9849]

Just another Microsoft short coming. It just seems like we are loosing more and more functionality.

[@TheEngineeringToolboxChannel]

@@nrups9849 agreed! It’s unfortunate

[@sonasondarasaesaria1941]

Does anybody know what's the solution for office 64 bit?

[@TheEngineeringToolboxChannel]

There is not a way to get this exact control to work on 64bit excel. You can look into “Microsoft Monthview” control as another control option. kzbin.info/www/bejne/fHO3p5isr75rock

[@sonasondarasaesaria1941]

@@TheEngineeringToolboxChannel OK I'll try it, thanks for the alternative option, really appreciate that!

[@fabriziocarboni976]

Thanks, i lost two day to resolve this problem.

[@TheEngineeringToolboxChannel]

Glad it helped!

[@charlesessien3676]

Thanks for the tutorial, i tried it but it didn't work. i use office 365

[@TheEngineeringToolboxChannel]

See pinned comment titled “trouble shooting tips”

[@Dhanashri001]

please show code for date picker.. im getting error method or data member not found

[@TheEngineeringToolboxChannel]

If you want to see the code go back and watch previous videos and follow along. kzbin.info/www/bejne/bXrEg2WmqJ19hJY If you want me to help you trouble shoot your problem you will have to give me more information about when you get the error, what you are trying to do, etc. The data member not found usually means you are referring to an object or object member that does not exist or properly defined. If you would like to send me your file I can definitely help [e-mail]

[@gustian_pandu7215]

How to combine upload foto

[@marcelo687]

It didn't work, I followed even the steps from the comment box, still not working. Good video tho

[@TheEngineeringToolboxChannel]

Likely you are using 64 but excel then. Sorry!

[@tricks4us365]

Can You Send Excel File...Please

[@TheEngineeringToolboxChannel]

But I just showed you step by step how to do this...

[@HariKrishna-my8bo]

@@TheEngineeringToolboxChannel i need vba code for that file..

[@TheEngineeringToolboxChannel]

Hari Krishna yep all the vba code that is in the file is shown step by step in these videos. kzbin.info/aero/PLAVcy54svukfRIuXILzMGtvL1FCAsa6XZ

[@mustafapatel3331]

Everything went well accordingly until I entered the path location in command prompt, a message popped up saying, "This file does not have an app associated with it for performing this action......."

[@TheEngineeringToolboxChannel]

Check file path again and make sure you spelled everything correctly in the cmd prompt

[@mustafapatel3331]

Awesome man, appreciate the support!

[@mymrs5294]

Windows 7 download

[@AbdulRehman-wn4wq]

it actually shown date picker button on my controls tab, but did not work

[@TheEngineeringToolboxChannel]

Did you add this control or was it already there?

[@AbdulRehman-wn4wq]

@@TheEngineeringToolboxChannel i add manually Mscomct 2 file, but didnot work

[@TheEngineeringToolboxChannel]

Did you review the trouble shooting tips in the pinned comment of this video? What year of excel are you on? And what bit version (32 or 64)?

[@AbdulRehman-wn4wq]

@@TheEngineeringToolboxChannel 64 bit 2016

[@TheEngineeringToolboxChannel]

@@AbdulRehman-wn4wq Paste the OCX file in the system32 folder. run command prompt as administrator. make sure the working directory is set to "C:/Widows/System32" (or wherever that folder is located on your machine) and run "regsvr32 *File path to your ocx file*. Have you done as described above and checked the pinned trouble shooting tips above? If these suggestions do not work, consider reinstalling excel as a 32bit version. Then follow the steps in the video exactly. I know its not the best answer but it seems like people are having issues with 64 bit versions of excel.