Calendar Control on a User Form VBA Excel Office 365 64bit

%3CLINGO-SUB%20id%3D%22lingo-sub-998610%22%20slang%3D%22en-US%22%3ECalendar%20Control%20on%20a%20User%20Form%20VBA%20Excel%20Office%20365%2064bit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-998610%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20Excel%202010%20it%20was%20quite%20easy%20for%20me%20to%20populate%20a%20date%20cell%20using%20the%20MonthView%20Contol%20I%20think%20from%20Microsoft%20Windows%20Common%20Controls%206.0%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20now%20using%3C%2FP%3E%3CP%3EOffice365%3C%2FP%3E%3CP%3EWindows10%2064bit%3C%2FP%3E%3CP%3EExcel%20VBA%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20the%20Calendar%20Control%20that%20should%20be%20an%20Additional%20Control%20in%20the%20ToolBox.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBrowsing%20research%20suggest%20that%20it%20may%20now%20be%20called%20Date%20and%20Time%20Picker%20Control%20in%20the%20mscomct2.ocx%20which%20does%20not%20appear%20to%20be%20installed%20on%20my%20system.%26nbsp%3B%20It%20is%20unclear%20where%20to%20download%20this%20file%20from%20and%20if%20this%20is%20for%2064%20bit%20machines.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-998610%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-999277%22%20slang%3D%22en-US%22%3ERe%3A%20Calendar%20Control%20on%20a%20User%20Form%20VBA%20Excel%20Office%20365%2064bit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-999277%22%20slang%3D%22en-US%22%3EHave%20a%20look%20at%20Ron%20de%20Bruin's%20page%20about%20this%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Fs8%2Fwin003.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Fs8%2Fwin003.htm%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1001852%22%20slang%3D%22en-US%22%3ERe%3A%20Calendar%20Control%20on%20a%20User%20Form%20VBA%20Excel%20Office%20365%2064bit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1001852%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks...%26nbsp%3B%20I%20am%20using%20that%20add-in%2C%20and%20it%20works%2C%20but%20I%20do%20not%20understand%20why%20a%20tool%20from%20Excel%202010%20and%20before%20is%20not%20included%20in%20Office365%20toolbox.%26nbsp%3B%20From%20what%20I%20can%20read%20the%20name%20was%20changed%20to%20Date%20and%20Time%20Picker%2C%20but%20the%20ocx%20file%20apparently%20is%20not%20for%2064bit%20machines.%26nbsp%3B%20Does%20not%20make%20sense%20that%20Office365%20would%20reduce%20the%20function%20of%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1002035%22%20slang%3D%22en-US%22%3ERe%3A%20Calendar%20Control%20on%20a%20User%20Form%20VBA%20Excel%20Office%20365%2064bit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1002035%22%20slang%3D%22en-US%22%3EI%20agree%20it%20is%20a%20pain.%20Microsoft%20does%20tend%20to%20go%20out%20of%20its%20way%20to%20ensure%20backward%20and%20forward%20compatibility%20is%20OK%2C%20but%20sometimes%20it%20does%20%22retire%22%20parts%20of%20Office.%3C%2FLINGO-BODY%3E
New Contributor

In Excel 2010 it was quite easy for me to populate a date cell using the MonthView Contol I think from Microsoft Windows Common Controls 6.0

 

I am now using

Office365

Windows10 64bit

Excel VBA

I am looking for the Calendar Control that should be an Additional Control in the ToolBox.

 

Browsing research suggest that it may now be called Date and Time Picker Control in the mscomct2.ocx which does not appear to be installed on my system.  It is unclear where to download this file from and if this is for 64 bit machines.

 

 

3 Replies

@Jan Karel Pieterse 

Thanks...  I am using that add-in, and it works, but I do not understand why a tool from Excel 2010 and before is not included in Office365 toolbox.  From what I can read the name was changed to Date and Time Picker, but the ocx file apparently is not for 64bit machines.  Does not make sense that Office365 would reduce the function of Excel.

I agree it is a pain. Microsoft does tend to go out of its way to ensure backward and forward compatibility is OK, but sometimes it does "retire" parts of Office.