Validation Pull-Down List

  • Thread starter Thread starter luv2waterski
  • Start date Start date
L

luv2waterski

I am using data validation to make a list box with several categories.
After the category is selected, it populates the next list box using
VLookup. However, on both list boxes I can only view 8 lines at a
time. I am asking for assistance in increasing the lines viewable
from 8 lines to about 30 or 40 lines at a time. Thanks for your help.

-Darren
 
I don't think it is possible, you need to use a combo box from the control
toolbox to be able to
control this..
 
I found contextures.com for data validation
instructions. Please tell me one thing though. I
created the lists and the dependent lists. And, I got as
far as using the INDIRECT function in the source box.
However, that is where I got stuck. The validation
worked for the first two rows but not the rows thereafter.
That is, I have a category list (fruit and veggies in A2
and A3). I entered =INDIRECT(A2) in hte source box for
the cells to be validated (C2:c6). I was able to select
fruit (and get the fruit list only)in c1 and vegetables
in c2 (and get the vegetables list only)but when I got to
c3, I only got the fruit list, even if I selected
vegetables. I looked a the data validation and it read
=indirect(a2) as instructed. Please advise where I went
wrong!!

Thanks!
 
There are instructions here for creating dependent dropdown lists with
data validation:

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

Items disappear from your list because you're using the active cells as
the source for the dropdown list. You should store the list on another
worksheet, or in an unused area of the active sheet.
 
Read through the instructions again, and download the Data Validation
sample from the link at the bottom of the page:

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

Set up the named lists in an empty area of your workbook, or on a
separate sheet. On the main worksheet, you'll have some cells that refer
to the produce list (=Produce), and in the adjacent column, use the
INDIRECT formula in the data validation dialog box.
 
I was afraid the answer was that it's not possible. At first we were
using a combo box and switched to the data validation because the
combo box was too volitale in that when we added products to the
product list, it would change the selection in the combo box of all
the past invoices. Guess we are stuck with 8 lines viewable for data
validation until we get the website done which is being programmed in
ASP.
 
Back
Top