Hi selltick1967:
In excel 2013 you need to install date and time picker manually, and there is no compatibility problem among excel 2007, excel 2010 and excel 2013.(NOTE:This Active-X control works only on 32-bit systems)
Following these steps and installing it:
Download Windows Common Controls-2 6.0 from link below:http://activex.microsoft.com/controls/vb6/MSCOMCT2.CAB
Microsoft Windows Common Controls-2 6.0 includes the following ActiveX controls:
1.Microsoft Animation Control
2.Microsoft UpDown Control
3.Microsoft MonthView Control
4.Microsoft Date and Time Picker Control
5.Microsoft Flat ScrollBar Control
For registering mscomct2.ocx:
Extract mscomct2.ocx from MSCOMCT2.CAB to C:\windows\system32 (windows 32 OS)
After registering you can use Microsoft MonthView Control like below:
a) Add calendar control to a userform
b) Add MonthView1_DateClick by double click the calendar control:
Private Sub MonthView1_DateClick(ByVal DateClicked
As Date)
On Error Resume
Next
'replace your code here for set cell value
Application.Cells(1,
1).Value = DateClicked
Unload Me
End Sub
c) Add worksheet change event:
Private Sub Workbook_SheetSelectionChange(ByVal Sh
As Object,
ByVal Target As Range)
If Target.Value =
"popCalendar" Then
CalendarForm.Show
End If
End Sub
d) Click cell A5 will show the calendar like below:
Hope its helpful.
Regards,