Dynamically Unhide Sheets with a Userform Listbox

I have a listbox that is populated dynamically by hidden tab names that start with the name "TEMP".

Please Login or Register  to view this content.

Then I have a button that is linked to the following Sub. When clicked each selected item in the listbox unhides the corresponding sheet.

Please Login or Register  to view this content.

This method works. But I would like the sheets to hide/unhide dynamically without having to click a button. I have tried a few methods using ListBoxTemp_Click(), but can not get it to work properly.

Any thoughts on how to accomplish this?

Problem I see is that when does vba know when you have made your last selection - possibly doubleclick on last selection or on exiting listbox or userform.

Thanks for the reply! This solution could work as a good alternative.

My thoughts were the loop would run every time an item is clicked on (either selected or unselected). For example, the user holds CTRL and clicks the 1st, 2nd and 3rd item to selects them. On each click the corresponding selection would unhide the tab. If the user clicked a forth time on the 1st item to unselect it, it would hid the tab when clicked. So for this example the loop would be run 4 times. Is this possible?

How about making the listbox single select & use this

Please Login or Register  to view this content.

Thank you for your help on this!

You're welcome