Trigger?

[khadeer]

Dear All,

I have one list box. I am using this list box in two different sheets. In one sheet user can select multiple values in that list box. In another sheet he can select any one value at a time.(Always one selected value). But when i am using always one selected value in list box its reflecting on both sheet. So my need is those selections not reflect on other sheet.

User can select multiple values in one list box. For same list box when i am using in another sheet user can select single value at a time. Which trigger i have to use.

Hope i explained clearly.

Regards,

Khadeer

[khadeer]

Dear All,

I am using QV10 , So i can't use comparitive analysis.

I have tried to take two listboxes also. But those properties are effecting to both listboxes.

When i am using sheet triggers as clear all when leave that sheet. but its not effecting to the properties of the object. Just its clearing other selections.

Thanks for all ur replies.

Regards,

Khadeer

[#3]

It's possible to do what you want.

For that, go in Document properties, in "States" and add one state for each one of your sheets. you can call your states "Sheet1" and "Sheet 2".

Then go in your 2 sheets' properties and select the right state for each one of them.

After that, any selection done in your listbox of sheet 1 will not alter the selection of your identical listbox in your sheet 2

Here's a link which explains better what I am saying:

Using Multiple Alternate States Combined with Set Analysis to Create a Comparison Chart – Part One |...