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