Validation Pull-Down Lists

  • 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
 
On another sheet type or copy the entries you want to see in the drop down list.
Select the cells in the list, click in the name box, (left of the formula bar), type name for the list, press the enter key.
Now go back to Data Validation and in the source =(the name of your list)
 
Back
Top