Combo Boxes

[raw]

Hi

I have a sheet with 2 combo boxes (from the forms tool bar)

Is it poss to change the input range of one when you make a selectio
from the other

eg
Combox one has 4 options
1. Eclipse
2. Milltex
3. New house
4. Westfar

So if you Select 2. then the second combo box with show the list fo
No. 2 (milltex) but if 4. is picked then the list for (westfar) wil
show in the second combo box

Im guess a macro will need to be assigned to the 1st combo box?????

Help

thank

 

[Norman Jones]

Hi Raw,

See xlDynamic's page on dependent dropdowns at:

http://www.xldynamic.com/source/xld.Dropdowns.html