Drop Down Calendar

Okay, in need of more help.

I would like to create a drop down menu within a cell that brings up a calendar, from which the user can click a date and that date is populated into the cell w/the drop down.

So far, I've not been successful, other than using the calendar control, which is a full-time displayed calendar that is bound to a single cell. I have a column of cells that each will potentially have a different date. I would like each cell to have independent drop downs, from which dates can be selected and populated accordingly.

All I've been able to find that is remotely close is this: http://danielcurran.com/instructions...ontrol-60-sp4/ Unfortunately, his recommended files that I downloaded did absolutely nothing. Any other ideas?

Thanks for looking.

Hello All,

I was assigned this project and would need some help in getting started. Basically what needs to be done is have a calendar (template which I downloaded off the web) and for each date there needs to be a drop down list with 3 selections. When selecting an option from that list a cell outside of the calendar will display a description of events for that team on that day. Therefore the description needs to be static and unique to the team.

any help would be great. I have adjusted the calendar template but thats about it. Oh! and filled out my 3 selections for my drop down list. Lets call them Peter, Paul, Mary.

Thanks.

Does anyone now how I can create a drop down calendar in a given cell. The kind that shows the small calendar icon and when click on you can pick month, day, year.

I am trying to make an interoffice work order for maintenance issues and need
to create a drop down calendar with a box with a button (icon) that when
clicked on shows the calendar to pick the date and enter it into the box. I
know how to insert a calendar that stays on the page but does not drop down.
I am using Microsoft Excel 2003. Help!!!!

Hi,

I want to make a calendar using VBA that fills in my calendar template in excel with the dates of the month e.g. 1 2 3 4 5.....31 but start them under the corresponding DAY. So Each month has a header starting sunday through to saturday and I want to get it so it starts the 1st of the month under the correct day. This is important as I want the calendar to be dynamic and update based on a drop down which chooses the year. Here is my project so far and on the sheet called calendar is the spec of what Im trying to do. i also saw this post about a vba calendar creator but I have no idea how to do this any help would be great.

http://www.ozgrid.com/forum/attachme...4&d=1147461706

thats the file

this is the post:

http://www.ozgrid.com/forum/showthre...light=calendar


My file containing what I've done so far:

http://www.excelforum.com/attachment...e-academic.xls

Hope you can help,

Andy