Today I’m going to show you How to clear the “Always One selected value” – ListBox property while moving to different sheets. By default, this is document level property and I’ll show you how to override this property to change when you move to different sheet. I’ll assume that you have basic understanding of Macros and Triggers. We can achieve this by using VB Scripting and Triggers.

I’ll demonstrate step-by-step process on how to get this done. Please contact me if you have any questions.

Just in case if you can’t watch the video from this site, you can use this link to watch from Youtube.

Thank you for watching. Happy learning.