Calendar control in Excel
In a particular cell where I need to enter date, I would like to have a calendar control so that when I need to enter the date, I can browse through the calendar and select.
Is there such facility available in Excel?
Software
In a particular cell where I need to enter date, I would like to have a calendar control so that when I need to enter the date, I can browse through the calendar and select.
Is there such facility available in Excel?
by abarnes70
Depending on your version....select Add-Ins from the Tools menu. Click the Automation button, and scroll down the list until you find Calendar Control (Calendar Control 10.0 in Excel 2002). Click OK and then OK again. You can then insert using by selecting Object from the Insert menu and clicking Calendar Control.
Double-click the Calendar to write code for it and you're away!
This discussion is closed to new replies.
Sort by Trending