The calendar form is displayed when it is double-clicked on any cell on the worksheet.Months are listed in the combobox control according to the user's system language starting from the month on the userform caption . The ControlTipText value of the clicked button on the userform is added to the active cell as a date. Details and sample file address : Excel calendar userform