datepicker

I have been trying to add a calendar to a cell to help with data entry. I have followed along with this youtube video on how to add a Date Picker and the steps worked except the outcome doesn't work for me. https://www.youtube.com/watch?v=kYNaiXmbcoA I am able to get the button to appear on...

How can I get DatePicker to work (or any other calendar function). I currently have a sheet with it on excel 2003 with only x32 (work PC). When I am building the macro/s on my home PC (2013 x64) it goes away and I can't seem to find it in the additional add-ins.

Problem Date and Time Picker & Monthview controls are not included as a standard since Excel 2010 (additionally there are some known issues). So the additional controls are buggy (>download< - >step by step<): Microsoft Date and Time Picker Control 6.0 (SP6) Microsoft MonthView Control 6.0...

Hi , I have excel where on few cells I have applied date Picker by hard coding it using below code , but I don't want to do that , I want in my sheet wherever cell is of date format , the moment I double click date picker should be opened , which in this case restricted to range hard coded . Any...

I am very new to VBA and would really appreciate any help that someone could offer - I need to be able to select multiple dates in datepicker, then, just by the sum of dates selected, populate the cell. Simply put, if I select 6 different dates, then the number 6 would be displayed in the cell...

my SUMIFS formula works great, until I change the cell with the date criteria to a DatePicker object. Any tips? I wanted the calendar popup because it is faster for some users, but it's okay if it won't work and they have to type in a date.

Hi there, I'm new to the field of macros. I would like to get the macro for duplicating a date, which is selected using date picker into same word file in a different location. Appreciate your kind support. :) Thanks in advance,

After exhausting every search I can think of I hope someone can help. I need a date picker option for Excel 2010. However, I do not want to download or install anything...as the file will be sent to many people who may or may not have the correct installed. So, is there anyone that has a...

Hi All, Is there a way to force a format into DatePicker. eg. If I select 6th February 2011 that it would either display and save date as 06 Feb 2011 or alternatively as 2011/02/06. Currently it displays as 2/6/2011 Thanks and Regards, Alan

Hi, I read somewhere that it is not a good idea to use DatePicker as it is possible that some potential users of my program might not have it on their machines. Is this true? If so is there a way of including it in my code? Regards, Alan

Hi I just did the upgrade from excel 2007 to 2010 and saw that the calendar control was not supported anymore by office 2010. I found the free wincalendar tool but it is not exact what I want. Any suggestion to replace the old calendar.ocx is welcom. Thanks in advance Al

...and I use the term "native" for want of a better term. I have a User Form with a MultiPage control. On different pages I have datePickers. The datePickers are set to a Format dtpCustom and the CustomFormat is "yyyy.MM.dd". This is the same for all the date pickers on all the multipages. In...