Want to be able to click on a cell and have a list box appear to give values to populate a cell

  • Thread starter Thread starter Richard Zellmer
  • Start date Start date
R

Richard Zellmer

I have a excel sheet that has some cells that I want to populate from a list
of fix values. Basicly I want to click on a cell and have a list box pop
up that lists our departments and be able to click one of the departments
and have that value populate the cell.

What is the best way to do this?
 
1) Create the list of departments, perhaps on a separate worksheet you'll
hide later. Optionally, you could name the list.
2) Select the cell
3) Choose Data | Validation...
4) In the Allow entry field, choose "List"
5) In the Source entry field, enter the range from step 1, either by using
the range name, or click the arrow to the right and navigate to the list
6) Click OK

For more info, search for the keyword "data validation" in the online help.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top