Need some information

[Anonymous]

Hi

I have three sheets ,each sheet has two list boxes . when i make a selection on one list box the associated data on the other list box gets selected ,and same will be repeated for all the sheets .

Now , i want to make selection should be effected on only sheet1  and other sheets should not get effected with selection of list boxes .

Any help will be appreciated

Thanks in Advance

[Anonymous]

Create Alternate States

and assign

State1 for objects on sheet1

State2 for objects on sheet2

State3 for objects on sheet3

[Anonymous]

Is there any way other than alternate states .???

[sushil353]

Hi,

You can apply trigger of Clear field on activating the sheet..

HTH

Sushil

[sujeetsingh]

There are two ways to handle this

> Fist one to add action on sheet

  One can set action of clear all on Leave for a sheet or tab. You can get the option from the sheet properties

> Second way is the Alternate states

    You can set alternate states and use each for each tab

Now both the ways have some pros and cons now you need to follow any one of them according

[sujeetsingh]

@rgv rand Please mark this thread with proper status.

[#7]

Hey Rgv Rand, yes its possible as Bhagirath stated with the same method below:

Create Alternate States

and assign

State1 for objects on sheet1

State2 for objects on sheet2

State3 for objects on sheet3

Keep posting such informative posts. I am from www.SIMpalm.com , a leading mobile app development company in USA.

[mightyqlikers]

Hi rgv,

you can put sheet triggers , like when sheet is active clear that filed

like this.

Thanks & Regards
Samwise

[#9]

Create 3 different alternate sheet with three name in Settings-->Document properties--->Alternate state and assign it in each sheet properties.

All three sheets will work independently.

Thanks,

sampath

[maxgro]

maybe with 2 trigger for every sheet and 3 bookmarks

- apply bookmark on activate

- replace bookmark on leave