My problem is i have given the "Always One Selected value" in List Box Propeties.When i will go to the next sheet i need to clear all the selections whatever i have made in the sheet.
I have given the trigger Clear All in On Activate sheet,except that List Box all selection are made clear.
Found this thread from some years ago but it is almost exactly what I am trying to do now.
I can't work out how you have got the ListBox to set to only one value? There is no calculated condition in the list box properties where I would expect to do this.
I think it's all described in the previous posts, it's basically all done in Settings - Document properties - Triggers and Sheet properties - triggers.
