ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing part of userform (https://www.excelbanter.com/excel-programming/312338-printing-part-userform.html)

Bhuktar S[_13_]

Printing part of userform
 

I have no. of pages in Multipage on Excel VBA form. Each page is wit
different informations in textbox, combobox etc.
On the userform there are some textboxes which have values applicabl
as common to all the pages of the Multipage.
I need to print each page & with each page the common data of th
userform.
How do I do it

--
Bhuktar
-----------------------------------------------------------------------
Bhuktar S's Profile: http://www.excelforum.com/member.php...nfo&userid=234
View this thread: http://www.excelforum.com/showthread.php?threadid=26599


Tom Ogilvy

Printing part of userform
 
me.printform

prints the userform. You will need to loop through the pages of the
multiform and make each on the top page, then do the print.

--
Regards,
Tom Ogilvy

"Bhuktar S" wrote in message
...

I have no. of pages in Multipage on Excel VBA form. Each page is with
different informations in textbox, combobox etc.
On the userform there are some textboxes which have values applicable
as common to all the pages of the Multipage.
I need to print each page & with each page the common data of the
userform.
How do I do it?


--
Bhuktar S
------------------------------------------------------------------------
Bhuktar S's Profile:

http://www.excelforum.com/member.php...fo&userid=2343
View this thread: http://www.excelforum.com/showthread...hreadid=265993





All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com