Userform displaying multiple worksheets

Hi guys,

I have an excel table that contains many worksheets. I am trying to make a userform, which displays all the worksheet and let's you select which worksheet you want to open. So the userform should consist of listbox and button. I've made the listbox to display all the worksheet, but can't manage the button. Please help ...

Here is the listbox configurationi:

Please Login or Register  to view this content.

Please edit your post to include code tags per the forum rules.

Dom

Here's something I had stashed away...

Dom

Or right click on the bottom left corner of the workbook to display a list