Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I create a drop box in Excel to show a calendar?

I'm trying to create a drop box within a cell in Excel so that when the user
click on the drop box, it shows a calendar and that the calendar will default
to today's date.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default How do I create a drop box in Excel to show a calendar?

You can try the Microsoft Date and Time Picker control.

Add the Control Toolbox menu to your toolbars. Select the last button that
looks like a hammer and wrench. Select the Microsoft Date and Time Picker
Control. Add that to your sheet.

--
HTH...

Jim Thomlinson


"V. Pham" wrote:

I'm trying to create a drop box within a cell in Excel so that when the user
click on the drop box, it shows a calendar and that the calendar will default
to today's date.

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
how do I create a drop down list with a calendar in excel claron Excel Worksheet Functions 1 February 7th 08 08:59 AM
Create a drop down/pop-up calendar in excel ruthie Excel Discussion (Misc queries) 1 September 21st 06 11:45 AM
How do I create calendar drop down box Melissa Excel Discussion (Misc queries) 2 August 3rd 05 05:32 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
create calendar drop down list in Excel sell Bo New Users to Excel 1 December 3rd 04 06:37 AM


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

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

About Us

"It's about Microsoft Excel"