| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a disapearing drop down list
I am trying to make a work schedule spreadsheet.
On another spreadsheet that I did not create I saw that you can go to a blank cell and a drop down arrow appears beside the cell which you can click and then you get a list to pick from to fill in the cell with text. Then when you move off the cell the whole thing goes away and you just have the item that you picked from the list showing How do you do this? I am just now learning how to record macros and program VBA so a really basic explanation will be much appreciated. thanks dzierzekr |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create a disapearing drop down list
This is schieved using Data Validation. Choose it from the menu and set up a
list under "Validation Criteria - Allow List" The entry "Designate valid cell entries" in the help file is useful. "dzierzekr" wrote: I am trying to make a work schedule spreadsheet. On another spreadsheet that I did not create I saw that you can go to a blank cell and a drop down arrow appears beside the cell which you can click and then you get a list to pick from to fill in the cell with text. Then when you move off the cell the whole thing goes away and you just have the item that you picked from the list showing How do you do this? I am just now learning how to record macros and program VBA so a really basic explanation will be much appreciated. thanks dzierzekr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ho do i create drop down list? | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
| How To Create A Drop Down List? | New Users to Excel | |||
Linear Mode
