Solved

Date and Time Picker Control - Calendar in upper left corner

Posted on 2014-01-08
4
3,619 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

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 40

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel ActiveX ComboBox enters a 0 if a list item isn't selected 41 42
If condition and Date Ranges 13 44
Determine dependencies 3 21
Checking references in VBA 3 22
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

740 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