Thread
:
Modifying a validating list
View Single Post
#
2
Posted to microsoft.public.excel.misc
Debra Dalgleish
external usenet poster
Posts: 2,979
Modifying a validating list
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.
wrote:
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?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Reply With Quote
Debra Dalgleish
View Public Profile
Find all posts by Debra Dalgleish