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...
HansVogelaar
Jan 26, 2021MVP
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.
TheOcean
Jan 26, 2021Copper Contributor
Sir using Excel 2016
- HansVogelaarJan 26, 2021MVP
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