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

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