Retain selections - Macro help

[tamilarasu]

,

I am using system field ($Field) in two sheets. Whenever the user do some selections in a sheet , it affects the other sheet as well. I want to retain (store the selections in a variable) the selections for two sheets and when switch back it should be restored. For example, I have two sheets named as "Sheet1" and "Sheet2". If the user made some selections in sheet1 and go to the sheet2, then the selections (From sheet1) must be stored in a variable. If the user switch to the sheet1 again, the selections should be fetched from the variable. Similarly for the sheet2.

Can anyone provide me the code.!!!!

Thanks in advance

P.S: I don't want to use alternate state.

[Gysbert_Wassenaar]

Use bookmarks. Create one bookmark for each sheet. Add a Replace Bookmark action to the OnLeave sheet trigger to save the selections of the sheet. Add a Apply Bookmark action to the OnActivate sheet trigger to restore the selections from the bookmark for the sheet.

[tamilarasu]

I have tried the above and it's working fine in my desktop. When I moved the application to access point, it seems replace bookmark not working. What could be the problem. ?

[b_garside]

This works flawlessly. Thanks for this idea.  Glad I found this post!

I really did not want to use variables for multiple fields.

[marcus_sommer]

Maybe this might be helpful: Tracking the historical selections.

- Marcus

[tamilarasu]

Old thread . Anyway, thank you Markus. I have already read the above link .