Run a macro on selected sheets in a workbook

[brianfosterblack]

I am using a listbox in a userform to select multiple client sheets. These are output to ("Other!AW:AW").
I need help with a macro which will take me to each of these sheets in turn and run a macro
I have a macro that runs on all my worksheets in a workbook but cannot seem to find one for this requirement
Can someone please help.

 

[Alex Blakenburg]

I need help with a macro which will take me to each of these sheets in turn and run a macro

See if this is what you had in mind:-
(if the code is not sitting in the UserForm module you will need to replace "Me" with the form name)

Sub ListBoxMultiSelect()

    Dim i As Long

    For i = 0 To Me.ListBoxName.ListCount - 1
        If Me.ListBoxName.Selected(i) Then
          Worksheets(Me.ListBoxName.List(i)).Select
          Call Macro_You_Want_To_rRun
        End If
    Next i

End Sub

 

[brianfosterblack]

See if this is what you had in mind:-
(if the code is not sitting in the UserForm module you will need to replace "Me" with the form name)

Sub ListBoxMultiSelect()

    Dim i As Long

    For i = 0 To Me.ListBoxName.ListCount - 1
        If Me.ListBoxName.Selected(i) Then
          Worksheets(Me.ListBoxName.List(i)).Select
          Call Macro_You_Want_To_rRun
        End If
    Next i

End Sub
[
[QUOTE="Alex Blakenburg, post: 5752766, member: 473943"]
See if this is what you had in mind:-
(if the code is not sitting in the UserForm module you will need to replace "Me" with the form name)

[CODE=vba]
Sub ListBoxMultiSelect()

    Dim i As Long

    For i = 0 To Me.ListBoxName.ListCount - 1
        If Me.ListBoxName.Selected(i) Then
          Worksheets(Me.ListBoxName.List(i)).Select
          Call Macro_You_Want_To_rRun
        End If
    Next i

End Sub

Hi Alex, this is not working for me. I have already extracted the items selected in the listbox and put it in a sheet ("Other") in a range named) ClientNamesSelected. I do not want to run the macro straight from the userform as I have other criteria also to take into account when running my macro and I still have to record these.
[/QUOTE]

 

[brianfosterblack]

Hi Alex, this is not working for me. I have already extracted the items selected in the listbox and put it in a sheet ("Other") in a range named) ClientNamesSelected. I do not want to run the macro straight from the userform as I have other criteria also to take into account when running my macro and I still have to record these.

[/QUOTE]
Hi Alex, I found my problem. I had unloaded the userform instead of hiding it

 

[Alex Blakenburg]

Sound like you have it sorted. Thanks for letting me know.