Microsoft Date And Time Picker Control 6.0 Sp6

  1. Microsoft Date And Time Picker Control 6.0 Sp6 Download
P: 22
I have an excel file that I have been working on bit by bit over a few years, that I use as a basic, personal task tracker. I've built in task/milestone differentiation and a Gantt chart that moves relative to the selected date. I created a few basic controls to set the Gantt chart view (back one week, back one day, today, forward one day, forward one week), and I set up a date picker to set the view to any date of the user's choosing.
I recently moved to Office 2010, and now I'm having a problem with the Date Picker. It keeps re-positioning itself to the top-left corner of the sheet when I open the file. I then have to enter 'Design Mode,' manually re-position it, then exit design mode, and everything works as it should. Specifically, the date picker is designed to hover roughly over H4:J5, but on load it positions itself over the row/column headings at the top-left, varying in size some times (some times it covers A1:C2, others it's A1:H7). The fix is the same every time.
I've tried re-sizing, re-positioning, re-building and changing properties of the date picker, but nothing seems to make it load in the right position or size.
Further complicating things, I have VBA code that lets me hide the first three rows (a 'header' of sorts) for when I want to get down to business, so the date picker needs to be able to move with rows 4-5 so that it stays relative to the date control buttons (fwd, today, back).
The file is normally in .xlsm, but bytes.com won't let me upload that, so I've converted it to .xls. I have confirmed that all of the VBA functionality and the error persist in the .xls version of this file (I mostly just want the extra layers of conditional formatting).
Is there VBA code that I could use to force it to a specific location, yet still have it move with the 'hide header' control?
Thanks in advance for any consideration you can give to this problem.
Attached Files
SAMPLE TASK TRACKER.xls (1.73 MB, 573 views)
Microsoft date and time picker control 6.0 (sp6) not workingMicrosoft Date And Time Picker Control 6.0 Sp6

Download Microsoft Date And Time Picker Control 6.0 (sp6) Microsoft Date And Time Picker Now when the form opens, it does default to today's date, but then I can't use the Date Picker - it just keeps jumping back to today's date when I try to select an alternative date. Download Microsoft Date And Time Picker Control 6.0 (sp6) Microsoft Date And Time Picker Now when the form opens, it does default to today's date, but then I can't use the Date Picker - it just keeps jumping back to today's date when I try to select an alternative date.

  • This package will not install these Common Controls if they do not already exist on the target system. This package cannot be uninstalled. This package is provided under the terms of the End User License Agreement and is intended for the following customers: Customers who are Microsoft Visual Basic 6.0 and/or Microsoft Visual Studio 6.0 licensees.
  • About Date and Time Picker Controls.; 7 minutes to read; J; D; S; M; M; In this article. A date and time picker (DTP) control provides a simple and intuitive interface through which to exchange date and time information with a user. For example, with a DTP control you can ask the user to enter a date and then easily retrieve the selection.

Microsoft Date And Time Picker Control 6.0 Sp6 Download

I have find MicroSoft TreeView Control 6.0(SP6) Microsoft Date and Time Picker Control 6.0 (SP6) question, Jul 23, 2007, in forum: Excel Misc. Use the Value property to convert the current text into a DateTime variable and return. This is to aid in sizing the control. 26 Aug, 2015 Admin Post navigation.