Forum Discussion

Wayne-eh's avatar
Wayne-eh
Copper Contributor
Jul 12, 2021

include combo box in IF Statement column

I'm not sure on all the correct terminology so please bear with me.

I have a combo box used to select a variety of lists - we'll call this the "master combo".  That all works fine.  I select from the drop down and I get the desired list displayed.

However, all but 1 of the lists that the "master combo" selects has combo boxes as well - we'll call these the "secondary" boxes.  I want the "Secondary" combo boxes to show up as part of the list so the user can make further selections.  Currently when the lists with "secondary" boxes are chosen, where the secondary boxes are supposed to be are simply "0"'s.

Any thoughts? 

Let me know if this is unclear.

Thanks in advance!
Wayne.

 

**Allow me to add and hopefully I can get some feedback.

Sheet 1 is my user selection sheet.  Sheet 2 is the tables/values sheet.

The "master combo" box is on sheet 1.  When the user makes a selection from the master combo, I'm using an IF statement to reference a linked cell which then places the selected table directly below this "master combo" box.  These tables, lists, are on Sheet 2. 

These tables contain anywhere from 2 items to 20 items incrementing by 2.  (so 10 options total)

The 2 item table is easy, it contains just top and bottom.  Every other selection has top and bottom and selectable options for in between.  For example, the 4 option has top/selection/selection/bottom.

The places where there is a selection is another combo box, the "secondary" combo boxes.

So....

Is there a way to get those secondary combo boxes to appear on Page 1 when the list they are in is selected in the "master combo" box?

Hope the additional helps.

THanks!

Wayne.

7 Replies

    • Wayne-eh's avatar
      Wayne-eh
      Copper Contributor
      Hi,
      Thanks for the file but it's pretty much exactly what I already had. Unless I'm missing something the secondary drop down lists don't show up in the main one here either.
      So either I'm missing something with what you came up with or I didn't explain it well in the first place. If better explanation is needed let me know. I can provide screen shots if that will help clarify things.
      Thanks
      Wayne.
      • Yea_So's avatar
        Yea_So
        Bronze Contributor

        Wayne-eh 

         

        Oh so you want the user to select the layers, and after the user selects the layers the layers drop downs will just magically appear in the main sheet?  If that's what you're looking for then VBA forms is the solution.

         

         

Resources