Sheet Hide or Show

[#1]

Hi,

In attached appliaction having a listbox(A,B,C,D) and Five Sheets(Main,A,B,C,D)

Now if i select only one value from Listbox then it should show that particular sheet

Ex: if i selected Lisbox = A, then ony Main and A should show and the rest should hide.

Now if i select any two or three values from Listbox then it should show that particular selected sheets

Ex: if i selected Lisbox = A,B  then ony Main , A and B should show and the rest should hide.

Ex: if i selected Lisbox = A,B,C  then ony Main , A , B , C should show and the rest should hide.

What condition can i provide for hiding or showing the sheets.

Thanks in advance.

[swuehl · Accepted solution]

For each sheet, you could set a Show Sheet conditional i general tab of sheet properties like:

=if(wildmatch(GetFieldSelections(Navigation,'-'),'*A*')>0,1,0)

and replace A with B,C,D accordingly.

[Miguel_Angel_Baeyens]

Hi,

You can easily use the Concat() function to know what values of Navigation are selected, and a Match() function to have them all in the same conditional, so for the Sheet A, the conditional should be

=Match('A', $(=Chr(39) & Concat(DISTINCT Navigation, Chr(39) & Chr(44) & Chr(39)) & Chr(39))) 

For the Sheet B

=Match('B', $(=Chr(39) & Concat(DISTINCT Navigation, Chr(39) & Chr(44) & Chr(39)) & Chr(39))) 

And so on.

The Concat() part will return a string of values comma separated and single quoted, like for example 'A','C' when A and C are selected. The Match() function return zero (false) when there is no match, and 1 or higher (true) if there are at least one match. This sheets will show and the others will hide.

Hope that helps.

Miguel