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:
Private Sub UserForm_Initialize()
Dim ws As Worksheet
Me.ListBox1.Clear
For Each ws In ActiveWorkbook.Worksheets
Me.ListBox1.AddItem ws.Name
Next ws
End Sub
Bookmarks