Data Validation List Dropdown Limits

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
 
Top