Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How can I set up a drop down box with a calendar in Excel?

I would like to set up certain cells on my spreadsheets with drop down boxes
that become a calendar from which you select the date. I know how to make the
boxes with lists but can a graphic calendar be included somehow?
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default How can I set up a drop down box with a calendar in Excel?

There is an activex control included in 2003 I think in the VBA references
that is a graphic calander.
Ben

--
When you lose your mind, you free your life.


"Peter Newman" wrote:

I would like to set up certain cells on my spreadsheets with drop down boxes
that become a calendar from which you select the date. I know how to make the
boxes with lists but can a graphic calendar be included somehow?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default How can I set up a drop down box with a calendar in Excel?

Hi Peter,

See Ron de Bruin at:

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


---
Regards,
Norman



"Peter Newman" <Peter wrote in message
...
I would like to set up certain cells on my spreadsheets with drop down
boxes
that become a calendar from which you select the date. I know how to make
the
boxes with lists but can a graphic calendar be included somehow?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a drop down/pop-up calendar in excel ruthie Excel Discussion (Misc queries) 1 September 21st 06 11:45 AM
how do I add a drop-down calendar in excel? MrsMac2000 Excel Worksheet Functions 1 April 5th 06 11:29 AM
how do I add a calendar function to excel as a drop down? Dennis Excel Worksheet Functions 1 May 26th 05 07:13 PM
How do you create a calendar drop down in excel? Calendar drop down box in excel Excel Programming 8 April 28th 05 07:42 PM
How do you create a calendar drop down in excel? Create a calendar drop down box Excel Discussion (Misc queries) 1 April 28th 05 04:00 PM


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"