windows 8, excel 2013, date and time picker

I need to build a spreadsheet in excel 2013 on a 32 bit operating system in windows 8. The spreadsheet then needs to be capable of being used on a client's computer that uses excel 2010.I need the date and time picker that was standard on excel 2007 and 2010 but its not standard on excel 2013.

How do I obtain it and install it in excel 2013 so that it works there and also on my client's computer in excel 2010?

April 10th, 2015 2:48pm

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,

Free Windows Admin Tool Kit Click here and download it now
April 13th, 2015 5:43am

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,

April 13th, 2015 9:42am

Thanks for the response guGuuuMy. Unfortunately, I downloaded the active control but was denied access when I tried to extract. Any reason? I need to make some progress ASAP. Thanks


  • Edited by BBTF 20 hours 41 minutes ago
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2015 6:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics