Solved

Stable datepicker tool for MS Excel 2010

Posted on 2015-01-19
7
117 Views
Last Modified: 2015-01-19
I am looking for a stable datepicker tool for MS Excel 2010. This tool should not use the MSCOMTL.ocx, or an activeX. It should work for 32 bit and 64 bit.
0
Comment
Question by:Frans_Truyens
  • 3
  • 2
  • 2
7 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 40557646
You have the Calendar Control 12.0 that reply on MSCAL.OCX
Microsoft Calendar Control 2007

Can I ask why not datepicker that use MSCOMTL.ocx ?

gowflow
0
 

Author Comment

by:Frans_Truyens
ID: 40557661
It needs to be a stable one. I have bad experiences with the treeview control. If a machine is updated, there are always problems.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40557672
well always when you consider non basic standard controls then you need to ensure you can update the machine with the .dll or ocx when needed.

There nothing called stable or not stable. There are rules for upgrade that one has to follow and when not then you get errors like can't load this or that object and then you need to make sure the ocx is installed on the machine and make sure you simply register it before trying to open the file. That's simple as this.

Outside all this you need then to stick to standard controls.

gowflow
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:Frans_Truyens
ID: 40557728
OK. I got it  Aren't there any Add-In's you can advise? A kind of custom userform?
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40557799
yes there is

use RDB Date Picker add-in  from  http://www.rondebruin.nl/win/addins/datepicker.htm
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40557808
and here another version too  http://www.excel-it.com/excel_datepickers.html
0
 

Author Closing Comment

by:Frans_Truyens
ID: 40558022
Thanks a lot.
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

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

911 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

16 Experts available now in Live!

Get 1:1 Help Now