Listbox in userform and printing sheets listed in the list box

[ease20022002]

Hi, I am trying to select multiple selections from a list box from a user form. The list consists of various sheet names.

I have set the list box up for multiple selections and I am trying to print all of the sheets that were selected from this form.

Here is the code I have been working on. Any help would be appreciated.

Private Sub CommandButton1_Click()
Dim wsName As Variant
With ListBox2
For i = 0 To .ListCount - 1
If .Selected(i) Then
wsName

End If
Next i
End With
End Sub

 

[SkipVought]

You have to build an array to reference multiple sheets

with Sheets(Array("Sheet2", "Sheet1"))

end with

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}