Have a look at these two sites for some examples of data validation:

xlDynamic: http://www.xldynamic.com
Dynamic Dependent Dropdowns:
http://www.xldynamic.com/source/xld.Dropdowns.html

Contextures: http://www.contextures.com
Data Validation -- Create Dependent Lists:
http://www.contextures.com/xlDataVal02.html
Data Validation -- Dependent Dropdowns from a Sorted List
http://www.contextures.com/xlDataVal13.html

But in the end you need a datatable of the options as Eva suggested.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Abe" wrote:

help please....

i am trying to create an order form. normally this would be easy
enough...item price x quanity etc, but there are some other variables.
allow me to explain....

1. let's say we are selling products 1 2 3 etc all the way to 250.

2. let's say that products 1 through 50 only should display options (styles)
of a b c d e f and g, while products 51 -100 should display options (styles)
of h i j k l m etc.

I was hoping the two things above could be in drop down boxes... so..for
example..a customer orders product 22, only the a to g options or styles are
shown.

Now..to complicate things a buit further, each style would have a different
price associated with it.

I was thinking somehow to have the products listed in a drop down box...and
depending on the product selected, would evoke some sort of condition (If
product = 22, display options a-g..where the options or styles are maybe in
an external file?

Does this make sense?

Hope so :)

Any ideas would be greatly appreciated. And please be gentle...I'm a
newbie...but then you probably know that already by the way I asked :)

Thaks in advance,
Abe