How to populated Listbox from Hidden sheet with rowsource property

Hi

In the attached sample WB I can populate Listbox from Sheet2 if sheet is not deactivated or hidden. But if I hide sheet2 or switch to other sheet then I don't see the items (just blank rows in listbox).
I need to set rowsource to populate and bound not to use loop to get listbox populated

Please Login or Register  to view this content.

Similar problem was solved here. https://www.excelforum.com/excel-pro...ml#post4809009 but I think in that situation I was using a combobox or I was using a loop to populate it while in current situation I want to set rowsource of Listbox

Help would be greatly appreciated

Edit1:
Also tried

Please Login or Register  to view this content.

but no luck

Best Regards
Imran Bhatti

Thanks Jindon
Worked like a charm.