Hi,

There are lot of examples in MrExel

http://www.mrexcel.com/archive/Controls/index.html


Try to look at this. It might help you.

http://www.mrexcel.com/archive/Controls/30062.html

kk


"ynissel" wrote in message
...
KK - The problem is I used Combo boxes not validation. Any ideas on doing
it
this way ?
Thanks.

"kk" wrote:

Hi

Take a look at

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



"ynissel"
wrote in message
...

I have list of products that are tied to rates.
one product has 5 rates and the second has 10 rates.
The product is chosen by a drop down box
I have a lookup to create a table with the rates- this is range named
"rates".
I have a drop down box linked to "rates" so a customer can choose the
product and the rate with drop down boxes.

My issue is that if the product with 5 rates is chosen then you have a 5
blank rows in the rate drop down box. Is there any way to link the drop
down
to 2 different range names - based on product - or is there some better
way
to do this ?

Thanks,
Yosef