Customizing excel
 

how to add a calendar in a drop-down list

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

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

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

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