How do I create a drop box in Excel to show a calendar?

V

V. Pham

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.
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Calendar in Excel with a Default Value 1
How do I insert a calendar box, in excel? 2
Is there any way to create a drop down calendar into a cell in ex. 1
calendar 2
How do you create a calendar drop down in excel? 1
Create Drop Down Box populated by a List 1
How do I do a drop down box with calender in excel? 4
How do i create a drop-down calendar in an Excel Spread Sheet? 2

Top