Best way to add drop down calendar

[dave.bangert]

I have several date inputs in some of my excel sheets. I would like to add a drop down calendar for these cells. How to proceed?

 

[VoG]

This may help http://www.fontstuff.com/vba/vbatut07.htm

 

[Alee Aasim]

Press Alt + D then L to open data validation window then Allow select List under source window put the reference of your data range click ok.

across the sheet if your need to insert drop down you need to assign name to your data then call it in data validation list.


regs,
aasim