Add a calendar as a drop down box for multiple cells

[ibanana]

Hi Excel genuises,

I need to add a calendar in multiple cells.
I have followed the following steps: Developer, Insert, More Controls, Microsoft Date and Time Picker Control 6.0 (SP4) and dragged the box wherever in the sheet.

However I need this selection to be reapeated for an entire row. ie I need the user to be able to select a date from a calendar for all the cells with the same column (Cloumn A).

Any ideas?


Cheers

 

[ibanana]

bump

 

[wmcs130]

Bump...I have this questions as well for Excel 2007, however, I am not able to find this Microsoft Date and Time Picker Control 6.0 from the More Controls options. Thanks for the help!

 

[mfexcel]

The More Controls icon is the last one (lower right) under ActiveX Controls

Bump...I have this questions as well for Excel 2007, however, I am not able to find this Microsoft Date and Time Picker Control 6.0 from the More Controls options. Thanks for the help!

 

[wmcs130]

Yes, I found the More Controls icon. I was stating that the Date and Time Picker is not listed as one of the options to select. How would you go about adding it? or is there another way? Thanks!

 

[wmcs130]

bump?

 

[mfexcel]

Show pop-up calendar upon right click [Excel VBA] | Chandoo.org - Learn Microsoft Excel Online
seems to be an answer for both of you; though i have not read tried that yet.
Good Luck.