Drop down Calendar Excel 2010

[Marsdbginner]

Dear Lords of Tek-Tips.com,
Please hear my cry and grant me wisdom!!!

I am trying to create a drop down calendar for a userform in excel 2010 whereby a resource can select a date and have it populate the drop down.
I must point out again that this is specific to 2010, not 2007; so, selecting 'Microsoft Date and Time Picker Control 6.0" isn't available..

I did find the Microsoft Outlook Date Control, but the ActiveX crashes my Form when I run.

ActiveX Error:
"This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this file, select OK and the controls will be initialized using your current workspace settings."
(I click OK)
"Run-time error '2147220995 (800401fd)': Automation error. Object is not connected to server."
(I suspect this is due to the ActiveX control attempting to reach out to the exchange server to figure out which month to show in the drop down and not finding a connection; thus run-time error)


Can anyone help me with a work around for this one; either with the ActiveX or maybe a selection that I'm not seeing that will provide me with the calendar of my dreams? *work appropriate of course


Any help would be greatly appreciated.

 

[SkipVought]

hi,

How about using some other control, like the Calendar Control?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Marsdbginner]

Hey Skip,
Great suggestion, however I can only guess at the exact function you're speaking of. Could you clarify just a bit?

One obstacle to this project is that the entire userform is nested in a cmdButton.. ie click the button and the form pops up; various other drop downs are populated such as Name, ProjectID, Task Description, Hours worked, and Comments and then the user clicks submit on the form to write the data to a table. Everything else works great save the date drop down.

The current work around is a hidden-columnQ on the data dump sheet with '=Today()' pulled down 45 cells to provide the past 45 days in the Date drop down on the userform. This work around doesn't create an issue but is just a little tacky with all those dates.

Thanks for the quick response.

 

[SkipVought]

alt+F11 will activate the VB Editor.

cntr+R will activate the Project Explorer

In the Project Explorer you will see a Forms object. OPEN it (+) and you'll see one of more individual UserForms. Pick the one you want and DOUBLE-CLICK that UserForm.

In the UserForm you'll see a Toolbox window. Right-Click in the window to add more controls and another window will open, listing a whole passel of controls, in which will be the Calendar Control.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Marsdbginner]

Not seeing an obvious selection for "Calendar Control"..

 

[Marsdbginner]

Sorry for the double-post, I hit return after pasting the url. It's just a snip of the Additional Controls window that i uploaded to imageshack.
After digging for a while in several forums and finding others reaching the same dead-end, it looks like this control wasn't carried into Excel 2010.. but I'm holding on to hope.

 

[Andrzejek]

select a date and have it populate the drop down.

Could you elaborate on this, please? And give some examples.

Do you want – for example – have a drop-down (list) with the list of dates from 5 days ago to 10 days into the future for your user to pick/choose from?


Have fun.

---- Andy

 

[PHV]

A quick and dirty search gave me this link:

http://www.mrexcel.com/forum/excel-...2010-missing-calendar-control-workaround.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886