Calendar Control In Excel Vba

This is how it looks in the danish version of excel 2003.

Calendar control in excel vba. In the u s a english where the first day of the week is sunday and not monday the day labels from left to right will be su mo tu we th fr and sa and february 1st. The calendar control of vba has changed between excel 2003 and excel 2010. Additionalcontrols jpg select the date picker control from the list of available active x controls.

Using the excel calendar control from excel 2010 onwards. It is unclear where to download this file from and if this is for 64 bit machines. These calendar controls are so nice for quickly s.

Newdatepickertoolboxicon jpg download link for. Newdatepickercontrolselection jpg once it is selected it can be used from the toolbox. The older versions have a control named as calendar and for the new versions it is called the dt picker control.

Once the control is registered it can be added to the control toolbox available in the vba area of excel. Right click on the vba user form toolbox and choose the option shown to reference the newly installed calendar control. 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.

On this page i show how to make a calendar and date picker on an excel userform using vba only and no activex. It is very easy to call this calendar for your vba project. This fully functional dynamic calendar control in vba we have designed to use in vba project.

But i believe that you should be able to right click on the userform toolbox in vba to add the calendar control as an additional control. First check the references of your vba project. You can call this with two method.