1 Reply Latest reply: Oct 15, 2010 9:06 AM by Miguel Angel Baeyens de Arce RSS

    Macro on Multibox selection

      Hi,

      I am using one multibox to show four different values - 1,2,3,4.

      Now on selection of each value i want to show respective sheets. e.g. on selection 1, sheet1 should be visible and on selection 2, sheet 2.

      Can anybody help me with the MACRO for it.

      Thanks.

        • Macro on Multibox selection
          Miguel Angel Baeyens de Arce

          Hello,

          If you want to show only that sheet which value is selected, you can go to the Sheet properties, General, Show Sheet, Conditional, SELECTION = 1, where SELECTION is the name of the field that stores those numbers 1, 2, 3, 4 and 1 is the number of each sheet.

          Without any selection, you won't see any sheets, once you select one value, the sheets will display accordingly.

          Is that what you need?