Hi I'm trying to put a clickable calendar on a worksheet, have followed numerous threads but my main issue is that I am missing Microsoft MonthView Control. Can't help you with the MonthView control. My Excel 2010 app references SP6 for the month view. My experience is that Excel automatically updates references when older ones are specified. A possible option is my free 'Get Your Own Date' excel add-in for xl97 thru xl2010 only. Apr 05, 2016 I cant find the Microsoft MonthView control 6.0 tool in Visual Basic for Excel 2013. 34 AM This forum is for Developer discussions and questions involving.

Microsoft Monthview Control 6.0 Excel 2007 Missing
Microsoft Monthview Control 6 0 Excel 2007 Missing Sheet Tabs
6 To The Power Of 0

Date Picker Add-in for Excel 2007 and up for Windows

Note: There are 6 languages supported on this moment :English, German, Español, Français, Russian and Danish.

Open Excel Open VB Editor; Activate Control Tools-References Select 'Microsoft Windows Common Controls 2-6.0 (SP6)' Userform Controls Select any userform in VB project Tools-Additional Controls Select 'Microsoft Monthview Control 6.0 (SP6)' Use 'DatePicker' control for VBA UserForm; Hope you get it right now, if not do let me know.

Right click on a worksheet cell and click on the Date Picker menu option to open the Date Picker.

Information

1) You can select any month and year with the arrow keys and click on Today to jump to today's date. When you click on the button with the ? you can read the information below how to insert the date or week number in the active cell.

Double-click on a day to Insert the date and the formatting.
Ctrl + double-click on a day to Insert the date only, using the default or existing date format.
Shift + double-click on a day to Insert the week number.

2) You have an option to insert a Live Calendar to your worksheet, click on the 'Insert Live Calendar' button, the screenshot below is for the ISO week number system. If you change the date on top of the calendar it will update the calendar automatic.

3) When you click on Change Settings the Date Picker you have the following options :

In the Settings section you can :

Choose a Date format in the dropdown that will be used when you double-click on a day. There is also an option to add one custom Date format of your own if you can't find one that you like in the dateformat dropdown menu.
Select the week number system that you want to use. Default = ISO Week numbers
There is an option to AutoFit the column width after it insert the Date. Default = AutoFit
There is an option that will open the calendar with the date selected that is in the active cell (if there is a Date in the cell) and not the default of the last Date that you inserted with the add-in.
There is a option to automatic close the add-in after you insert a Date or Week number.
You can change the language of the user interface of the Date Picker in: English, German, Español, Français, Russian or Danish on this moment. But It will open automatic in the language of your Excel language version if it exists, if not it will use the English language.

Download and Install information

Excel 2007 and up

1) Download the RDB Date Picker add-in (Version 1.6 for Excel 2007 and up: 7-March-2019). Many thanks to John McGhie, Mourad Louha, Sergio Alejandro Campos, Bernard Rey, Vladimir Zakharov and Dan Elgaard for the translations of this add-in.

Note: In version 1.6 it is also possible to use the add-in if you not have Format Columns checked in the sheet protection dialog if you protect your sheet. Format Cells is still needed when you protect your sheet.

2) Copy WinDatePicker.xlam to a unprotected directory on your system.
Tip: Use one folder for all your add-ins (easy to back up your add-ins this way)
3) Start Excel and open a workbook.
2007: Click the Microsoft Office Button, click Excel Options, click the Add-Ins tab.
2010 and up: Click on File, click on Options, click the Add-ins tab.

In the Manage drop-down, choose Excel Add-ins, and click Go. Use 'Browse' to select the add-in and then click on OK. Verify that the Date Picker is checked in the add-in list and then click OK.

4) Right click on a worksheet cell and choose Date Picker to open the user form.

Note: The add-in is available as freeware. But you can use the Contact button in the menu if you want to support the development of this Date Picker add-in.

Microsoft Monthview Control 6 0 Excel 2007 Missing

Note: There is also a version for Excel for the Mac, Check out this webpage if you want more information about the Mac add-in.

Note: If you can't find the menu item in the Cell menu and the add-in is checked in the Add-ins dialog see this website for more information : http://peltiertech.com/Utility30/Documentation30/RibbonDisappears.html

Open the Date Picker with VBA code for in your worksheet

With the code below you can open/close the Date Picker, you can use the macro below in other VBA projects to open/close the Calendar to insert a date in your worksheet instead of using the menu item in the Cell menu.

To get the last date picked in the Date Picker you can use :

Note : If you want to open the Date Picker from inside your own userform be sure that you open your userform Modeless, with the second macro you can fill in the picked date inside a control if you want.

Similar Messages:

Excel 2010 :: 32bit - Microsoft Date And Time Picker Control 6.0 Missing

Nov 7, 2013

I am trying to add a calendar picker to Excel 2010. Everything I read online says that it is possible, you just need to use the ActiveX control 'Microsoft Date and Time Picker Control 6.0', and that it should be listed under Developer Tab -> Insert -> More Controls ->... But it's not listed.
I also tried downloading the Microsoft Windows Common Controls-2 6.0, but when I tried to add it to Excel using 'Register Custom...', it says 'Cannot register this control'.
Why this control is missing? and I can't add it?

Use Microsoft Date And Time Picker Control 6.0 (SP4) In Protected Sheet?

Apr 23, 2013

I am using the Microsoft Date and Time Picker Control 6.0 (SP4) from the more controls option on the developer Ribbon. The issue I have is when I protect the sheet I lose the functionality?
I have ranges selected as editable by user when the protect is on - this includes the linked cell to the date picker but it still doesn't work.

Microsoft Date And Time Picker

May 14, 2006

i have just discovered the Microsoft date and time picker. at the moment i have a text box on my userform into which i put the date.can i use code to transfer the date to the text box or do i use the date picker instead of the textbox. if i used the date picker what is the code for the date picker

Date And Time Picker Control

Feb 28, 2003

I recently reformatted my hard drive and reinstalled my software. Now I don't seem to have the Date and Time Picker Control (among others) that I used to.
I did a thourough install of Microsoft Office 2000 Professional, and switched from Windows 98SE to Windows 2000 Professional. Isn't that control standard in such an installation? If its not, where can I get it?

Date And Time Picker Control In 2007

Aug 29, 2007

I have some excel tools developed in Excel 2003 which uses the date and time picker control (DtPicker). When I open my files in Excel 2007 the DtPicker is missing and the change_event will not load the calendar. I cannot find and activate the datepicker in the Reference base.

Microsoft Monthview Control 6.0 Excel 2007 Missing

Date And Time Picker Control Value Messes Up Subsequent Formulas

Jun 17, 2013

I have just added two date

Microsoft Monthview Control 6 0 Excel 2007 Missing