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

I show you how to add a date picker (calendar) control to a our VBA userform for data entry in excel 2016. These calendar controls are so nice for quickly selecting dates from a drop -down list.

- - - - - - - - - - - - - - - - - - - -

Check out my channel for more videos and tutorials for engineers!

Like, follow, share and don't be afraid to drop me a comment/message with feedback, questions, or video suggestions!

Thanks for watching!

[Channel Link]

- - - - - - - - - - - - - - - - - - - -

[Social]

- - - - - - - - - - - - - - - - - - - -

[Tags]
#EngineeringToolbox
#VBA
#ExcelForEngineers
#EngineeringTutorials
#ProjectManagement

[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.

[SwissMarkus]

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

[mustafapatel]

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

[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.

[llobj]

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!

[FrancisAAfful]

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

[jjoel]

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

[joanmontana]

Nprjoan thanks for the calendar control

[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

[bbierman]

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?

[LamNguyen-WordUnveiled]

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

[piseyleang]

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

[roronoazoro]

still the date picker wont show in the additional tool list

[justcallmekrishmusic]

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

[AamirSaeedTajalli]

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

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

[rubinatorable]

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

[wayneseymour]

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.

[vasanthviswa]

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

[erkanbey]

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 :)