 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Picking a Date to Populate a Cell
Please go easy on me because I'm brand new to Excel. I am trying to find a way to 'select' a date to populate a cell rather than having to 'type' it in. Is there a way I can use the Data Validation drop-down function to call up an interactive calendar from which I can pick a date? If not, is there another way it can be done? Do a search on "+ excel calendar add-in", and you'll find what you are looking for!  SignatureHth Kassie Kasselman Change xxx to hotmail > Please go easy on me because I'm brand new to Excel. I am trying to find a > way to 'select' a date to populate a cell rather than having to 'type' it in. > Is there a way I can use the Data Validation drop-down function to call up > an interactive calendar from which I can pick a date? If not, is there > another way it can be done? hi, you can use the built in calendar control. Ron de Bruin explains it well at his site. http://www.rondebruin.nl/calendar.htm regards FSt1 > Please go easy on me because I'm brand new to Excel. I am trying to find a > way to 'select' a date to populate a cell rather than having to 'type' it in. > Is there a way I can use the Data Validation drop-down function to call up > an interactive calendar from which I can pick a date? If not, is there > another way it can be done? Here is how I would do it. Select Tools -> Customize -> Toolbars (tab) and check Control Toolbox. This will bring up the Control Ttoolbox Toolbar. Click the icon that looks like a Hammer and Wrench. From the list choose Microsoft Date and Time Picker Control. Your cursor will change to a cross hair that you can use to draw the control (the same way you would draw a rectangle using click and drag). Right click the control and select Properties. Add a cell reference (such as A1) to the Linked Cell property. Now to get out of design mode click on the Triangle & Ruler icon on the control tollbaox toolbar. SignatureHTH... Jim Thomlinson > Please go easy on me because I'm brand new to Excel. I am trying to find a > way to 'select' a date to populate a cell rather than having to 'type' it in. > Is there a way I can use the Data Validation drop-down function to call up > an interactive calendar from which I can pick a date? If not, is there > another way it can be done? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.