How to create a disapearing drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

Pick from drop-down list gives empty or erroneous result 6
Colour-coding a cell from a drop down list 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Help with creating drop down 1
EXCEL DROP DOWN 2
Prevent duplicate entries within a range of cells from a drop-down 3
Drop Down List Format 2
Drop Down List 2

Back
Top