ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add drop down calendars (https://www.excelbanter.com/excel-discussion-misc-queries/124168-how-do-i-add-drop-down-calendars.html)

fzeiba

How do I add drop down calendars
 
I am building a multiple sheet orderform (template). I want to have
"calendars" available as drop downs in certain fields for date selection. I
understand how to utlize the Data...Valadation... in order to add a drop down
of a list in a work sheet, however I have been unable to find a way to add a
calendar. Any and all recomendations are appreciated.............Thank you.

Gord Dibben

How do I add drop down calendars
 
Have a peek at the instructions and code at Ron de Bruin's site.

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


Gord Dibben MS Excel MVP

On Sat, 30 Dec 2006 15:10:00 -0800, fzeiba
wrote:

I am building a multiple sheet orderform (template). I want to have
"calendars" available as drop downs in certain fields for date selection. I
understand how to utlize the Data...Valadation... in order to add a drop down
of a list in a work sheet, however I have been unable to find a way to add a
calendar. Any and all recomendations are appreciated.............Thank you.




All times are GMT +1. The time now is 02:28 AM.

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