Drop-Down calendar possible?

[network_engineer]

Hi all,

Is it possible to have a drop-down calendar in Excel? If yes, how would I accomplish that? E.g. if I wish to have all cells in Column C to have a drop down that would then show me the calendar.

Kind regards.
Ben

 

[P_Guru]

Try using named ranges and data validation - potentially using INDIRECT

 

[VoG]

Try this http://www.fontstuff.com/vba/vbatut07.htm