Forum Discussion
TheOcean
Jan 26, 2021Copper Contributor
POPup calender in COl"A"
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
3 Replies
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.
- TheOceanCopper ContributorSir using Excel 2016
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