ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I add a drop-down calendar in excel? (https://www.excelbanter.com/excel-worksheet-functions/81612-how-do-i-add-drop-down-calendar-excel.html)

MrsMac2000

how do I add a drop-down calendar in excel?
 
I would like to add a drop-down calendar to a cell in Excel that you can use
to select the date - the date will then appear in the cell.
(a bit like when you book a holiday on-line and you can choose the dates!)

I can get round it by using a combo box and adding all the dates into a
spreadsheet but wouod be nice if you can see a visual little calendar.

Bob Phillips

how do I add a drop-down calendar in excel?
 
See http://www.rondebruin.nl/calendar.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MrsMac2000" wrote in message
...
I would like to add a drop-down calendar to a cell in Excel that you can

use
to select the date - the date will then appear in the cell.
(a bit like when you book a holiday on-line and you can choose the dates!)

I can get round it by using a combo box and adding all the dates into a
spreadsheet but wouod be nice if you can see a visual little calendar.





All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com