Data Validation (TEXT BOX?)

[pujo]

Hello World,
When using "Data Validation" to create a list box, then using the list box in data validation to return named range valuse, it creates another list box.

=INDIRECT(RANGE NAME)

Is there a way I can make it display all values in the range without using a list box?
I have up to 100 different items in the range, and I do need to see them all at the same time.

Thanks,
PuJo

 

[mrmmickle1]

Take a look at these two websites: Dependent Listbox, Dynamic Named Ranges

They should help clear up your issues.