Alternate states and triggers

[kinjal1645]

Hello,

I have 3 list boxes in different sheets in different alternate states(at sheet level): Main(no alterante state), Project1 (state P1), Project2 (state P2)

If T1 is selected in Main then T1 should be selected in other tabs. Similarly for other tabs, when T1 is selected in Project1 then T1 should be selected in other tabs.

It is working between Project1 and Project2 but not with Main.

Can you let me know how to make it work for all tabs?

Thanks,

Kinjal

stalwar1swuehlgwassenaartresescojagan

[sunny_talwar · Accepted solution]

You seem to have made it super complex, but see if this helps

[kinjal1645]

I know but I couldn't think of anything else . These fields are not associated and are mutually exclusive when in same state.

Thank you for your solution. It is working for T2 but behaving weird for T1/t1 in Main tab for me. Select T1/t1 in Main > go to other tab > switch back to Main > T1/t1 is deselected.

Also, if you know how to do this when more than one value is selected?

[kinjal1645]

It is working now. I made slight change in trigger expression on Main tab.

Thanks stalwar1