Hello
I have created an excel workbook with a number of worksheets. I have also created a userform1 from excel developer where all the worksheets are visible in a menu, each worksheet has a checkbox against it, each worksheet has a separate small macro. When a user opens the workbook they are presented with this menu, the idea is when the worksheet is selected in the menu it will run the macro associated with that worksheet but how do I call the macro when the worksheet is selected in the menu.
• The user is presented with the menu
• The user will physically go the tab in the worksheet and fill in some data, there may be more than one worksheet to update.
• The user returns to the menu I created and selects the worksheets which will run the macro, each worksheet has a different macro but I have managed to get them working just need help on the calling them from the menu(userform) part. I thought about going to each worksheet and placing a macro button on it and assigning it to the macro however I think this would look professional.
This code behind the userform is below, it allows me to select the sheet but having problems calling the associated macro once the sheet is selected

Any help will be appreciated

Sub OKButton_Click()
Dim i As Integer, MaxItem As Integer
Dim outputstring As String
Dim itemselected As Boolean

MaxItem = Me.SheetSelector.ListCount - 1

With Me.SheetSelector
For i = 0 To MaxItem
itemselected = .Selected(i)
If ((Me.IncludeSelected And itemselected) Or Me.IncludeAll) Then
outputstring = outputstring & "," & Me.SheetSelector.List(i)
ElseIf (Me.ExcludeSelected And (Not itemselected)) Then
outputstring = outputstring & "," & Me.SheetSelector.List(i)
End If
Next
End With
MsgBox Mid(outputstring, 2)
End Sub

Sub UserForm_Initialize()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Me.SheetSelector.AddItem ws.Name
Next
Me.IncludeSelected = True
End Sub