Drop-down almanac
 

Ho do I add an almanac to cells to make it easier to pick a date?
--
Jose

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

Drop-down almanac
 

You mean Calendar?

Jose wrote:

Ho do I add an almanac to cells to make it easier to pick a date?

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?

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?