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