Pulldown

  • Thread starter Thread starter DR
  • Start date Start date
D

DR

I have in the past put a pulldown in a cell, letting the user click a
little downward triangle and then click a choice to populate the cell.
I can't remember what this is called, so can't use the help to look it
up. Could someone remind me? Thanks. Also I seem to recall finding it
impossible to provide more than two items in the pulldown. Is that
still (v2000) the case?
 
Debra said:
You can use data validation to create drop down lists in cells. There
are instructions in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html
Click to expand...

I did the same thing a number of years ago but the button for the
drop-down list was only visible when I put the pointer over the cell.
Everyone said that it was too hard to have the button visible all the
time. Is it still the same? If not, how would you do it?
 
Thewre were three suggestions.

1. Color the cell for recognition.

2. Draw an arrow or whatever next to the cell.

3. Us e a combo box from the Control Toolbox or Forms Toolbar.

The first two should be straightforward.

The combo box would require that you read the Help section on "combo box".


Gord
 
Back
Top