| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customizing excel
how to add a calendar in a drop-down list
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customizing excel
Right click on any visible tool bar and click on CONTROL TOOLBOX to open the
controls toolbar. Clcik on the MORE CONTROLS button (it has a hammer and wrench, workers of the world unite icon) and look to see if you have the Microsoft Date and Time Picker. The list is alphabetized so scroll down to the M's before you give up. If this is loaded then it will produce a calendrical drop-down box. -- Kevin Backmann "Roro" wrote: how to add a calendar in a drop-down list |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customizing excel
hI Kevin
Thank you for your help. But, what if the "Microsoft Date and Time" picker is not part of the list. Roro "Kevin B" wrote: Right click on any visible tool bar and click on CONTROL TOOLBOX to open the controls toolbar. Clcik on the MORE CONTROLS button (it has a hammer and wrench, workers of the world unite icon) and look to see if you have the Microsoft Date and Time Picker. The list is alphabetized so scroll down to the M's before you give up. If this is loaded then it will produce a calendrical drop-down box. -- Kevin Backmann "Roro" wrote: how to add a calendar in a drop-down list |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customizing excel
I'm fairly certain that the Microsoft Date and Time picker is available in
Excel 2000 on up. If it's not in the list you can re-run your install of Excel or Office and just install any missing features. This should do it. -- Kevin Backmann "Roro" wrote: hI Kevin Thank you for your help. But, what if the "Microsoft Date and Time" picker is not part of the list. Roro "Kevin B" wrote: Right click on any visible tool bar and click on CONTROL TOOLBOX to open the controls toolbar. Clcik on the MORE CONTROLS button (it has a hammer and wrench, workers of the world unite icon) and look to see if you have the Microsoft Date and Time Picker. The list is alphabetized so scroll down to the M's before you give up. If this is loaded then it will produce a calendrical drop-down box. -- Kevin Backmann "Roro" wrote: how to add a calendar in a drop-down list |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customizing excel
Hi Roro. Try Ron De Bruin's site at http://www.rondebruin.nl/calendar.htm.
HTH -- Sincerely, Michael Colvin "Roro" wrote: how to add a calendar in a drop-down list |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel MDI/SDI/Excel Instance to behave more logically | Setting up and Configuration of Excel | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Linear Mode
