Adding Microsoft Date Picker to Excel VBA Userform

%3CLINGO-SUB%20id%3D%22lingo-sub-1245910%22%20slang%3D%22en-US%22%3EAdding%20Microsoft%20Date%20Picker%20to%20Excel%20VBA%20Userform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245910%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%20I'm%20trying%20to%20make%20a%20userform%20in%20Excel%20VBA.%20I%20need%20to%20add%20a%20date%20picker.%20But%20that%20isn't%20available%20in%20the%20list%20of%20available%20tools%20(Not%20in%20additional%20tools%20list).%20I%20saw%20a%20tutorial%20on%20Youtube%20for%20adding%20this%20tool.%20The%20method%20includes%20downloading%20and%20copying%20a%20file%20named%20%22mscomct2.ocx%22%20into%20windows%20directory%20%22Syswow64%22%20and%20registering%20it.%20I%20did%20that.%20But%20even%20after%20following%20the%20procedure%20there%20is%20not%20date%20picker%20in%20the%20list.%20Can%20anyone%20please%20help%20me%20with%20that%3F%20How%20do%20I%20add%20a%20date%20picker%20to%20my%20userform%3F%20Thanking%20in%20anticipation.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1245910%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1246201%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Microsoft%20Date%20Picker%20to%20Excel%20VBA%20Userform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1246201%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20to%20use%20an%20alternative%20solution%20as%20offered%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fsites.google.com%2Fsite%2Fe90e50%2Fcalendar-control-class%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsites.google.com%2Fsite%2Fe90e50%2Fcalendar-control-class%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445103%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Microsoft%20Date%20Picker%20to%20Excel%20VBA%20Userform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F590664%22%20target%3D%22_blank%22%3E%40MahboobQadri%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20Just%20right%20click%20on%20Controls%20Toolbox%20-%26gt%3B%20Select%20Additional%20Controls%20-%26gt%3B%20Select%20%22Microsoft%20Date%20and%20Time%20Picker%20Control.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445289%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Microsoft%20Date%20Picker%20to%20Excel%20VBA%20Userform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445289%22%20slang%3D%22en-US%22%3EThat%20control%20is%20not%20available%20on%20all%20systems%20and%20was%20deprecated%20I%20think%20with%20Office%202013%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1729001%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Microsoft%20Date%20Picker%20to%20Excel%20VBA%20Userform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1729001%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F590664%22%20target%3D%22_blank%22%3E%40MahboobQadri%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20register%20the%20following%20TWO%20DLL's%3A%20MSCOMCT2.OCX%20%26amp%3B%26nbsp%3BMSCOMCTL.OCX%3C%2FP%3E%3CP%3EBeen%20using%20this%20date%20picker%20for%20years%2C%20and%20very%20happy%20with%20it...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi Everyone, I'm trying to make a userform in Excel VBA. I need to add a date picker. But that isn't available in the list of available tools (Not in additional tools list). I saw a tutorial on Youtube for adding this tool. The method includes downloading and copying a file named "mscomct2.ocx" into windows directory "Syswow64" and registering it. I did that. But even after following the procedure there is not date picker in the list. Can anyone please help me with that? How do I add a date picker to my userform? Thanking in anticipation. 

 

4 Replies
I would suggest to use an alternative solution as offered here: https://sites.google.com/site/e90e50/calendar-control-class

@MahboobQadri 

Hi, Just right click on Controls Toolbox -> Select Additional Controls -> Select "Microsoft Date and Time Picker Control.

That control is not available on all systems and was deprecated I think with Office 2013

@MahboobQadri 

You need to register the following TWO DLL's: MSCOMCT2.OCX & MSCOMCTL.OCX

Been using this date picker for years, and very happy with it...