But what if the user makes some selections (you'll never know how many different selections) in the other tab?
You can bookmark your selections in tab1 prior clearing it and then recall the bookmark when returning, please have a look at these threads and samples:
Hope this helps,
I am using the bookmarks.
In sheet1, i have the listbox a1 which i clear it on sheet2 onActivate Trigger.
In sheet1, i have applied onLeave sheet, i have given Replace Bookmark and onActivate i have given Apply Bookmark. Is this correct?
or Am i going wrong?
I want the listbox a1 selection when i come back to sheet1 from sheet2.