I have a UserFrom in Excel with Multipage control with 4 pages. I have a
command button that sends the page to print. However, this only sends to
print the active page. I would like to know how I can use that same command
button to send the form to print all multipages in the form? Can this even
be done? Could someone please help me with the code. I am new to Excel
Userforms. Thank you in advance for any help you can provide.

Iterate through them all and print them, in a loop.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"TotallyConfused" wrote in
message ...
I have a UserFrom in Excel with Multipage control with 4 pages. I have a
command button that sends the page to print. However, this only sends to
print the active page. I would like to know how I can use that same
command
button to send the form to print all multipages in the form? Can this
even
be done? Could someone please help me with the code. I am new to Excel
Userforms. Thank you in advance for any help you can provide.

Would this print each separtely? I would like for the forms to print in one
page can this be done? How?. Thank you.

"Bob Phillips" wrote:

Iterate through them all and print them, in a loop.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"TotallyConfused" wrote in
message ...
I have a UserFrom in Excel with Multipage control with 4 pages. I have a
command button that sends the page to print. However, this only sends to
print the active page. I would like to know how I can use that same
command
button to send the form to print all multipages in the form? Can this
even
be done? Could someone please help me with the code. I am new to Excel
Userforms. Thank you in advance for any help you can provide.

No it would print all separately. Never done what you asked, so I can't see
how it would be done. Sorry.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"TotallyConfused" wrote in
message ...
Would this print each separtely? I would like for the forms to print in
one
page can this be done? How?. Thank you.

"Bob Phillips" wrote:

Iterate through them all and print them, in a loop.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"TotallyConfused" wrote in
message ...
I have a UserFrom in Excel with Multipage control with 4 pages. I have
a
command button that sends the page to print. However, this only sends
to
print the active page. I would like to know how I can use that same
command
button to send the form to print all multipages in the form? Can this
even
be done? Could someone please help me with the code. I am new to
Excel
Userforms. Thank you in advance for any help you can provide.