Sheet level - Change the selection value

[muthukumar77]

Hi,

In qvw file, i have created two sheets. Sheet1 and Sheet2.

Each Sheet should be change the selection value automatically.

Please any one suggest me.

PFA

[swuehl · Accepted solution]

Maybe like attached, using OnActivateSheet trigger with a Selection - Select in field action in sheet properties.

[sunny_talwar]

Not sure what you are looking for? If you go on Sheet1, it gets selected in A list box? and when you go to Sheet2, it gets selected in A list box? If yes then you can try Sheet level triggers like the attached file.

[muthukumar77]

Hi,

When you go to sheet1, list value should be select Sheet1 value.

When you go to sheet2, list value should be select Sheet2 value.

[sunny_talwar]

Did you look at attached QVW? it is doing exactly that.