Calendar Control Excel 365

To resize the datepicker control turn the design mode on and drag a corner of the control.

Calendar control excel 365. 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. To adjust the code look also in the class module. I m on the insiders office 365 version of 64 bit excel and was hoping that someone could point me in.

I don t use office 365 but i am very familiar with using the date picker in a userform. Sadly i ve learned that 64 bit excel doesn t have a built in date picker. Instead users can use date picker or their own custom calendar controls so we have tried date picker and our experience is that it is not easy to use in existing applications.

Hiyas i have a spreadsheet where there s a field in my table for a date. Have a look at my code and the names of my controls. With that in mind please let me know if you want the date picker in the textbox which can t be done or just have the user s selection show up in a textbox.

I am looking for the calendar control that should be an additional control in the toolbox. Alternatively with the design mode on select your calendar control and click properties. Choose more controls from activex controls.

Currently i m entering in the date manually but i wanted to try my hand at create a userform with vba and for the date i wanted a date picker. Calendar control mscal ocx is removed in access 2010 and is not usable for excel 2010. Choose microsoft date and time picker control 6 0 sp6 from the list and click on ok step 6.

Calendar opens in textbox 2 and 3 when you enter the boxes. I am now using. Click anywhere on the worksheet to create the drop down calendar.