Tab click event

[Anonymous]

Hello,

I have an application developed by someone.  There's a bunch of tabs where you can click.  Each sheet has a list box.  Depending on which tab you click, the list box changes based on clicking the tab.  For example, say there are three tabs - tab1, tab2 and tab3.

If I click on tab1, the list box may show the values 1, 2 and 3.  If I click on tab2, the list box may show the values 10, 11 and 12.

Can someone tell me where is the code behind the clicking of the tab?  I need to see how values are being populated in the list box.

Thanks!

[oknotsen]

Go to the Sheet Properties. The last tab is the Triggers tab. Check there.

[NareshGuntur · Accepted solution]

Go to Sheet Properties --> Triggers --> OnActivate/OnLeave

Action might have been added here something to show only the respective values based on the sheet.

Cheers,

Naresh

[rwunderlich]

Is the listbox using an expression to set it's values. Each listbox definition may be different.

-Rob

[Anonymous]

Thank you all for your quick responses.

I found it.

[oknotsen]

Please do not flag your own reply as "Helpful" as it was not and it is also a bit rude to all the people in this topic who actually have been helpful.

Please flag the Correct Answer (assuming your question is answered) and optionally Helpful replies (of others).

If your question has not been answered, please be clear about what information related to your initial question you are still looking for.

[oknotsen]

Since you flagged my useless reply as "Correct Answer" and left your own reply as "Helpful", I am going to fix this, but please do this correct yourself next time.