Clear other fields

[#1]

Hi I have a listbox(Listbox1) with values Sheet1,Sheet2,Sheet3. Based on selection a new sheets appears.

I have an issue whenever I select Clear all , Selections should not apply on my Listbox1.

In sheet properties I have tried Clear other fields action but it does not work.

Please suggest on how can resolve this without using buttons.

[Anonymous · Accepted solution]

I edit Sridhar's solution.

You have to change the condition on all the tabs.

Is this what you are looking for?

[#3]

It Works. Thank you Dennis and Sridhar.