Separate (independent) selection in each sheet

[#1]

Hi QV friends,

I have some (maybe basic) questions:

1.) I have some QV project (ver.9.00.7257) and it has a number of sheets. In script are defined some SQL selects (from MySQL database tables).

On first sheet I have following ListBoxes: "Category" (Partneri.KategoriaPartnera), "Subcategory" (Partneri.PodkategoriaPartnera), "Place" (Partneri.Obec), "Name of partner" (Partneri.NazovPartnera).

On second sheet are following ListBoxes: "Name of supplier" (Partneri.NazovPartnera WHERE Kategoria='Supplier'), "Name of buyer" (Partneri.NazovPartnera WHERE Kategoria='Buyer'):

Now I would want in each sheet separate select of parameters. Because now if I select in first sheet some selection, then that selection is automaticaly set in second.

I would want in first sheet make some (manually) selection of data and in second sheet stay empty selection. Means possible make selection independently in each sheets.

thanks for tip

[#2]

for detail explanation of current state I attach other picture:

...

[#3]

Hi

the one solution will be when activate Tab2 to trigger "save" selections made on Tab1 (via bookmark or variables using macro) and clear selections made on Tab1. After return to Tab1 to apply saved selections.
Is this scenario is ok to post the code?

[#4]

hi Stefan,

can you write down real solution. I'm affraid that I don't understand your advance.

[#5]

HI JurajChovan ,

Only thing you have to do for getting different selection for each sheet is,

Assign triggers on activie event of sheet

You can achive these by following steps..

1. Right click on sheet (Make sure you are not clicking on other object)

2. Click on Properties

In triggers tab You can see the "on active sheet" and a button blow that "Add Actions"

3. Click button "Add Actions"

4. Click on Add Button

5. Select Action Type As Selection

6. Select Action as Clear All

7.Click ok

Try your selection

Best wishes

Kaushik