Solved

Date and Time Picker Control - Calendar in upper left corner

Posted on 2014-01-08
4
3,242 Views
Last Modified: 2014-02-20
I have a user running Excel 2010 SP2 32bit and he wants to add a calendar control to his spreadsheet using Microsoft Date and Time Picker Control. When he adds it and gets out of Design Mode, the calendar goes to the upper left corner outside of the spreadsheet itself. It does not stay in its intended location.

I uninstalled/reinstalled Office and downloaded/installed latest version of MSCOMCT2.OCX. OS is Win7-64SP1.

Thanks in advance!
0
Comment
Question by:brainsurf1
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:als315
ID: 39765888
I think it is bug in Excel. On any reason Top value is not used until you change it manually. Open properties of Picker and change value in Top parameter:
TopNow Picker will be on proper place
0
 

Author Comment

by:brainsurf1
ID: 39765993
Hi als315,

There was a value for Top; I did change it and the calendar moved and stayed in place and did not go to the upper left corner. However, when the document was saved and later reopened, the calendar reverted back to the upper left corner.
0
 
LVL 39

Accepted Solution

by:
als315 earned 200 total points
ID: 39767313
Yes, it is correct and seems correction of this bug is not planned by MS. I see only one solution (you can, of course, use form with calendar instead of ActiveX):
add sub to your worksheet:
Private Sub Worksheet_Activate()
ActiveSheet.DTPicker21.Top = 40       ' \Correct name of DTPicker and position
End Sub
0
 

Author Comment

by:brainsurf1
ID: 39789069
(Waiting for my user to try this suggestion--will post an update when he applies this fix)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to move the last 4 digits of a number to a new column 8 44
MS Excel IF AND OR statement 3 31
Excel Hyperlink Question 4 33
Excel 17 37
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now