Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Reply
Miguel_Angel_Baeyens

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?