When you change the value in combobox1, how do you populate the list for
combobox2?
And are these comboboxes on a userform or are they on a worksheet?
If they are on a worksheet, are they from the Forms toolbar or from Control
toolbox toolbar?
littlegreenmen1 wrote:
ok, i think i realize where i'm not making myself clear. the number of
options for combo box #2 varies depending on what you choose from combo
box #1. so, in order to include all the possiblities (from our color
example earlier) i would have to set the row amount to 9 in combo box
#2 to include all the colors. but, if i picked size, the row amount
for combo box #2 would still be 9 even though i only need it to be 3.
how i have it setup: cell a1=color a2=size. then, in b1:b9 (if combo
box #1=color) is the list of colors; if combo box #1=a2, then b1:b3 are
the sizes and b4:b9 are "0". b1:b9 change depending on what you select
in combo box #1. the range for combo box #2 has to be b1:b9 to include
all the colors. and in order to display all the colors i have a row
amount of 9 (i could set it to 3 and that would help my problem but
then i would have to scroll alot because in my actual form the number
of choices varies from 3 to 100+). having the row list amount at 9 is
fine for color, but if it's size that's 6 rows longer than i need which
are simply filled with blank space. again, it's not that big of a deal
for a difference of 3 to 9, but from 3 to 100+ that's a lot of blank
spaces. so what i'm trying to do is set the listrow amount equal to
the number of cells in b1:b9 that have a value other than 0, but i dont
think i can include a formula under listrow amount, i think it has to be
simply a range of cells. i hope this helps to clarify. if you need any
more information or if you need me to try and say it a different way
please let me know. i really do appreciate the help.
--
littlegreenmen1
------------------------------------------------------------------------
littlegreenmen1's Profile: http://www.excelforum.com/member.php...o&userid=23978
View this thread: http://www.excelforum.com/showthread...hreadid=376843
--
Dave Peterson