UserForm and calling different macros

[Dinamo]

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

[mongoose36]

Dinamo, welcome to the excel forum!!

You should be able to call the macro directly in the OKButton_Click event by name. For example if you have created another macro named

Please Login or Register  to view this content.

Then when you wish to call that particular sub just type the name

Please Login or Register  to view this content.

Hopefully that makes sense...also in future posts please try to use code tags (the hash tag in the WYSIWYG) around all your code to help differentiate it from normal text. See rule 3 of the forum rules

Best of luck!