MultiPage UserForm Printing Problem

J

jennie

Hi,

I have a user form (UserForm1) which has a multipage area in i
(MultiPage1) with 4 different pages.

At the moment I can print any single one of the pages using:

Sub PrintForm()

UserForm1.MultiPage1.Value = 3
UserForm1.PrintForm

End Sub

To print page 4 for example

I would ideally like to print all 4 pages together on one sheet o
paper (i.e. quarter sized)

Does anyone know how to do this?

Also, is it possible to change the background colour of the userfor
and multipage so that it doesn't print and waste ink.

Thanks for any help in advance
Jenni
 
T

Tom Ogilvy

none of this is supported directly.

You could possibly go through each page, copy it as a picture and paste to
the worksheet, then when you have all 4, print the worksheet.

If you really want just the "information", you could extract the values and
place them in cells with appropriate labelling, then print that range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top