Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Picking a Date to Populate a Cell

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.
--
HTH...

Jim Thomlinson


"Jim Farren" wrote:

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formula not picking up 1st of the month (weekday) Ang Excel Discussion (Misc queries) 3 September 5th 07 01:58 PM
picking out date ranges mlearner Excel Worksheet Functions 2 February 9th 07 06:59 PM
Populate a cell with a date using calendar pick Shane Nation Excel Discussion (Misc queries) 2 January 29th 06 07:48 PM
Automatic Populate Todays Date in Cell when File is Saved. Nello Excel Discussion (Misc queries) 3 April 21st 05 11:08 PM
Formatting a cell to populate on a certain date Brian Excel Worksheet Functions 6 February 16th 05 02:10 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"