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

Actually nevermind, I will simply use John Walkenbachs printing userform and
modify it for my needs. Thanks.

http://j-walk.com/ss/excel/tips/tip48.htm

EM

"ExcelMonkey" wrote:

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

As long as you recognize that that doesn't use a Userform. It uses a
dialogsheet. The controls are from the forms toolbar.

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
...
Actually nevermind, I will simply use John Walkenbachs printing userform
and
modify it for my needs. Thanks.

http://j-walk.com/ss/excel/tips/tip48.htm

EM

"ExcelMonkey" wrote:

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

Yes I know that Tom. That is why I was trying to avoid it in the first
place. But decided due to time pressure that it would suffice.

EM

"Tom Ogilvy" wrote:

As long as you recognize that that doesn't use a Userform. It uses a
dialogsheet. The controls are from the forms toolbar.

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
...
Actually nevermind, I will simply use John Walkenbachs printing userform
and
modify it for my needs. Thanks.

http://j-walk.com/ss/excel/tips/tip48.htm

EM

"ExcelMonkey" wrote:

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

Guess I was confused when you said:

I will simply use John Walkenbachs printing userform

<g

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote:

Yes I know that Tom. That is why I was trying to avoid it in the first
place. But decided due to time pressure that it would suffice.

EM

"Tom Ogilvy" wrote:

As long as you recognize that that doesn't use a Userform. It uses a
dialogsheet. The controls are from the forms toolbar.

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
...
Actually nevermind, I will simply use John Walkenbachs printing userform
and
modify it for my needs. Thanks.

http://j-walk.com/ss/excel/tips/tip48.htm

EM

"ExcelMonkey" wrote:

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