I have a macro which loads sheet names into an array called SheetArray. The
loading portion of the macro is manual as seen below. I want to set this up
so that the user is prompted with a userform with a list of available sheets
in the workbook. The user can the pick the desired sheets (check box or
whatever) and then the # of chose sheets will then make their way Dim stmt
below and the actuall sheets themselves will make their way into the array
below through some sort of loop. Any ideas how to do this.

Dim SheetArray(0 To 3)

SheetArray(0) = Sheet3.Name
SheetArray(1) = Sheet5.Name
SheetArray(2) = Sheet6.Name
SheetArray(3) = Sheet17.Name

Thanks

EM