If you watch the video at the end of the reddit post, you will understand what I'm trying to achieve. The code is also provided in the post. Any help will be appreciated. Thank you.
This is what I'm trying to get to: I first check what workbook is selected then depending on the workbook selected, I fetch it's available worksheets and display it in my combo box.