Modifying a validating list

[zaxhouse]

I am creating a spreadsheet for data collection and using validating
lists. I'd like to do two things to reduce keystrokes.....
1 - have the list appear when the cell is picked, instead of having to
pick the cell, then the down arrow.
2 - modify the length of the list box so that all values are shown
without the scrollbar. The length would vary for the various columns
but if there is a global setting that would be ok too.

I realize these properties can be modified in combo boxes and list
boxes, and have considered using them, but is there an easy way to copy
these down 150 rows for all the records in the sheet, much like you can
drag a cell down to copy formulas to all other cells?

Thanks in advance.

Zax

 

[Debra Dalgleish]

If you can use programming, there's a sample file here that provides a
single combobox, from which you can select one of the values from the
data validation list:

http://www.contextures.com/xlDataVal10.html

You could modify the code so it displays the combo box when the cell is
selected.