i am trying to find a way to resize a combo box depending on how many
possible choices there are. for example, i have a combo box (cb#1)
that allows me to select from a list of vendors. the drop down size of
this box stays constant. then in the second combo box (cb#2) a list of
materials is displayed. my problem is that not all vendors have the
same number of materials. so if i select vendor A (who has 3
materials) in cb#1, then i would like cb#2 to have a drop down line
amount of 3. then if i pick vendor B (who has 100-item long list) i
would need the drop down line amount to be 100. right now it's set for
the maximum number of drop down lines which is a bit overkill if there's
only 3 items. i dont know if it matters but i'm using the combo box
from the form toolbar not the control toolbar. any help on my dilema
would be much appreciated. thank you in advance.


--
littlegreenmen1
------------------------------------------------------------------------
littlegreenmen1's Profile: http://www.excelforum.com/member.php...o&userid=23978
View this thread: http://www.excelforum.com/showthread...hreadid=376843