Drop Down Menu's

gclearmonth

New Member
Joined
Sep 10, 2008
Messages
4
Hello,

I have just created a drop down menu and I would like to improve the presentation of it slightly. Basically I am entering a calendar into a cell as a drop down menu for employees to select, and would like them to be able to actually type "September 25" into the cell, and the cursor would move directly to that option for them to click.

I know of another way to do this but not without restricting user access. Basically I want it to be as simple as possible because many people will be using this spreadsheet and I would like to maintain control over it where possible.

Also, as a side note, does anyone know of any VBA code where I could actaully click on the cell and a calendar would pop up for them to select the date on? That would be best!

Thanks for your help.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,099,624
Messages
5,469,771
Members
406,669
Latest member
Rubrob

This Week's Hot Topics

Top