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

--
ra
-----------------------------------------------------------------------
raw's Profile: http://www.excelforum.com/member.php...fo&userid=2831
View this thread: http://www.excelforum.com/showthread.php?threadid=48333

Hi Raw,

See xlDynamic's page on dependent dropdowns at:

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


---
Regards,
Norman



"raw" wrote in message
...

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 selection
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 for
No. 2 (milltex) but if 4. is picked then the list for (westfar) will
show in the second combo box

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

Help

thanks


--
raw
------------------------------------------------------------------------
raw's Profile:
http://www.excelforum.com/member.php...o&userid=28312
View this thread: http://www.excelforum.com/showthread...hreadid=483331