Dynaic drop down list boxes for data validation

[Queryman]

I have a list box with five unique items, currently I have them in one list and there is another list box with about 20000 percentages that I am using.

What I need to do is for each of the five items on the 1st list, have the second list box dynamically list anywhere from 1 to 20000 percentages, is this possible?

I have seen examples where a two column table is created, but since I have so many percentages, I am not sure whether that would be the way to go here.

Any suggestions would be highly appreciated.

Thanks



Michael

 

[SkipVought]

Michael,

take a look at

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

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884