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.
Maybe like attached, using OnActivateSheet trigger with a Selection - Select in field action in sheet properties.
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.
When you go to sheet1, list value should be select Sheet1 value.
When you go to sheet2, list value should be select Sheet2 value.
Did you look at attached QVW? it is doing exactly that.
Retrieving data ...