Calander in Spreadsheet

[Guest]

How can I for example if I click on Cell 2-A get a Calander to pop up and
click on the date and it will populate the cell with the date selected.

 

[Gord Dibben]

See Ron de Bruin's site for how to set up a calendar in a cell.

http://www.rondebruin.nl/calendar.htm


Gord Dibben MS Excel MVP

 

[Guest]

Is there a way for example you have a spreadshheet with information and in
Cell C=5 it requires a date. The cell has a notion of somesort that once you
click it a calendar opens and you can select a date and it will fill the
cell. Something like on the airlines reservation system where you need dates
entered.

Thanks

 

[Gord Dibben]

Did you visit Ron's site?

He provides all you need to have a calendar that pops up when you click on a
cell.


Gord

Is there a way for example you have a spreadshheet with information and in
Cell C=5 it requires a date. The cell has a notion of somesort that once you
click it a calendar opens and you can select a date and it will fill the
cell. Something like on the airlines reservation system where you need dates
entered.

Thanks

Gord Dibben MS Excel MVP