Multiple tabs in an application - listbox hierarchy

[#1]

Hi,

I have an application that has multiple tabs. Each tab may be selected to refer to a particular sheet. I used variables for this. This works good. The tabs have sub tabs under them. Now, I want to have a hierarchy of the tab and sub tab names in a listbox such that clicking a tab/subtab in the listbox would direct us to the particular sheet.

Can someone help me with this please?

Thanks in advance.

[oknotsen]

I can only help you with the hierarchy look:

Make a list of the values, with every tab or sub-tab on a new line in the list. Sub-tabs should have their super-tabs added, having the values split by some "separator" value, like a dash or a slash.

Next, in the ListBox, turn on "Show as TreeView" and make sure you update the Separator to whatever you have used.

Example of the data (though with people instead of tab names) with a # as separator:

Erik

Erik#Helen

Erik#Helen#AngryBird

Erik#Helen#Sylvester

Erik#Helen#Tweety

Erik#James

Erik#Patricia

Erik#Patricia#Karin

Erik#Patricia#Karin#Bert

Erik#Patricia#Karin#Ernie

Erik#Patricia#Karin#Frodo

[#3]

Thank you for the reply. It sure helps. But, how do I make sure that clicking on a name would redirect it to that specific sheet?