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

Dynamic switching between tabs/Sheets

Hi All,

Can anyone help me in switching between tabs.

My requirement is as soon as I enter value in input box all the related information present in next tab i.e., sheet should be visible.

Ex: If input box is in sheet1 and all related charts is in sheet 2

Then automatically sheet 2 must be visible when we enter value in input box of sheet 1.

Waiting for the response

Regards,

Prajna

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can add a Activate Sheet action to the OnInput variable trigger of the variable of the input box. You can find the triggers on the Triggers tab of the document properties window.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

You can add a Activate Sheet action to the OnInput variable trigger of the variable of the input box. You can find the triggers on the Triggers tab of the document properties window.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for the help

Regards,

Prajna