+ Reply to Thread
Results 1 to 5 of 5

How to solve the problem of missing Calendar control 12.0 in excel 2010?

  1. #1
    Registered User
    Join Date
    08-23-2014
    Location
    1285
    MS-Off Ver
    2007
    Posts
    21

    How to solve the problem of missing Calendar control 12.0 in excel 2010?

    Hi,

    I am facing an issue where calendar is not working at all in Ms excel 2010 which is working fine in 2007. I have used Calendar control 12.0 logic in 2007. I understand that 2010 doesn't have this ocx compatible which is causing this issue.

    Problem is I don't have Microsoft date picker as well in 2010. Please can anyone suggest an easy way to make it working in 2010 excel without much changes in code? If that's not possible at all, please suggest some easy way to do it.

    Code used in 2007:
    ------------------------------------------
    Private Sub Calendar1_Click()
    ActiveCell.Value = CDbl(Calendar1.Value)
    ActiveCell.NumberFormat = "dd/mm/yyyy"
    ActiveCell.Select
    If Calendar1.Value Then
    Calendar1.Visible = False
    End If
    End Sub

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.Count > 1 Then Exit Sub
    If Not Application.Intersect(Range("D4:D11, B4:B11, F4:F11"), Target) Is Nothing Then
    Calendar1.Left = Target.Left + Target.Width
    Calendar1.Top = Target.Top + Target.Height
    Calendar1.Visible = True
    Calendar1.Value = Date
    ElseIf Calendar1.Visible Then Calendar1.Visible = False
    End If
    End Sub
    ----------------------------------------------------
    Regards,
    Anu Arora
    Last edited by ANUARORA; 08-26-2014 at 12:52 PM.

  2. #2
    Registered User
    Join Date
    08-23-2014
    Location
    1285
    MS-Off Ver
    2007
    Posts
    21

    Re: How to solve the problem of missing Calendar control 12.0 in excel 2010?

    Any excel expert here who can help please ???
    Last edited by ANUARORA; 08-27-2014 at 12:53 PM.

  3. #3
    Registered User
    Join Date
    08-23-2014
    Location
    1285
    MS-Off Ver
    2007
    Posts
    21

    Re: How to solve the problem of missing Calendar control 12.0 in excel 2010?

    Please reply if anybody is aware of the answer?

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: How to solve the problem of missing Calendar control 12.0 in excel 2010?

    Hi Anu,

    It seems the Calendar Control and then DTPicker weren't included as problems were found in them. I heard there were some potential virus concerns with them, but I never proved it. Find the attached which is a home made Calendar control. Perhaps you can start using this one or a few others that are all within normal VBA code, see attached. There are a few others that look differently that have been submitted to this forum.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Registered User
    Join Date
    08-23-2014
    Location
    1285
    MS-Off Ver
    2007
    Posts
    21

    Re: How to solve the problem of missing Calendar control 12.0 in excel 2010?

    Thanks a lot Marvin for the help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calendar Control for use with Excel 2007, 2010, and 2013?
    By Frankf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2013, 04:49 PM
  2. [SOLVED] MonthlyView ActiveX Control: How to add Pop Up Calendar in Excel 2010 in specific cell
    By sofib09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2013, 12:28 PM
  3. Excel 2010 Month View Control missing
    By Luphai in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2013, 08:48 AM
  4. Excel 2010 calendar control issue
    By santhisrinivas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 09:30 AM
  5. Excel 2010 calendar control issue
    By santhisrinivas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 09:30 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1