Retain the selection while moving to different tabs.
I have a 4 tabs in QV file. When I move to from one tab to other tab and make any selection in listbox the last tab listbox selection also get change. What I did, I make a default selection and created a BookMark for that selection.
What I want whenever I come back to my previous tab the bookMark selection should apply automatically.
I have tried using In the Sheet Properties ---> Triggers --->on activateSheet. But its not working.