POPup calender in COl"A"

[TheOcean]

I have been trying to Popup a calendar in Col"A", whenever i click on any cell of Col"A" then a calendar should be popup to put the the date in cell.

I have tried to create the calendar but it is not working can someone please check the below attached sheet.

Your help will be greatly appreciated

[#2]

@TheOcean 

Which version of Office are you using? The code uses the Calendar Control; this control was included with versions of Office 2007 and earlier that included Access, but not with more recent versions.

[#3]

Sir using Excel 2016

[#4]

@TheOcean 

That means that the Calendar Control is not available, so you won't be able to use it.

As an alternative, you might use the date picker from Ron de Bruin's free add-in Use a Calendar control or Date Picker to fill in dates