| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-down almanac
Ho do I add an almanac to cells to make it easier to pick a date?
-- Jose |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop-down almanac
On the control toolbar there is a Hammer and Wrench icon. Click on taht and
you will get a listing of controls. Find the Date & Time Picker control and add it to your spreadsheet. If you right click the control you can add a linked cell where the date will be placed. You need to ensure the spreadsheet is not in Design mode to use the control. Click on the Traingle and Ruler icon to toggle in and out of design mode... -- HTH... Jim Thomlinson "Jose" wrote: Ho do I add an almanac to cells to make it easier to pick a date? -- Jose |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop-down almanac
You mean Calendar?
Jose wrote: Ho do I add an almanac to cells to make it easier to pick a date? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop-down almanac
See Ron de Bruin's site for creating a pop-up Calendar.
http://www.rondebruin.nl/calendar.htm Gord Dibben MS Excel MVP On Wed, 3 Sep 2008 10:59:01 -0700, Jose wrote: Ho do I add an almanac to cells to make it easier to pick a date? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop-down almanac
Yes, I meant calendar.
Thanks I'll try the suggestions. -- Jose "Gord Dibben" wrote: See Ron de Bruin's site for creating a pop-up Calendar. http://www.rondebruin.nl/calendar.htm Gord Dibben MS Excel MVP On Wed, 3 Sep 2008 10:59:01 -0700, Jose wrote: Ho do I add an almanac to cells to make it easier to pick a date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Create new drop down from previous drop down selection | Excel Discussion (Misc queries) | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Linear Mode
