Changing Combo Boxes

soopial · Feb 11th 2003

I have a copy of Dave's CHANGING COMBO BOXES but I STILL can't figure out how to do it. Please tell me the "underlying" method that if I create a list of dresses in drop down box A(bridesmaid, bridal, flowergirl, etc.) then the corresponding mfr. would be available from drop down box B, please!!

THANKS!!

btadams · Feb 11th 2003

You need to have a formula like this:

=ADDRESS(2,H4) &":"&ADDRESS(100,H4)

where cell H4 is the linked cell for the first drop-down (p.s. are you using the drop-downs from the Forms toolbar?)

Then you need to create a named range (Insert -> Name -> Define) called MyRange and in the Refers to: box put the formula

=OFFSET(INDIRECT(Sheet1!$H$6),0,0,COUNTA(INDIRECT(Sheet1!$H$6)),1)

where H6 is the cell containing the Address functions

soopial · Feb 12th 2003

:bouncy:

Your instructions were so helpful. And, yes the drop down box is from the FORMS menu/toolkit.

Thanks again!

Changing Combo Boxes

Participate now!

Share