Printing Chart and UserForm on same page

P

Phil Wilson

Hi,

I have a workbook with several graphs driven by values on
multiple sheets.

I have set up a UserForm to focus users on the variables
they can change.

I would like to be able to print the settings on the
userform on the same page as a chart when the user
chooses to print it out.

I am thinking of setting a "static" image (ie GIF) of the
userform as the footer of the chart, however I am
struggling with how to do this straightforwardly as I
can't seem to use the nifty .export method for the
UserForm (plus I would prefer to not have to export the
image to an external file)

Any suggestions??

Phil Wilson
 

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

Similar Threads

paste 2 charts on the same image on a userform 2
Userform to Select what worksheets to print 1
Macro to print specified range of several work sheets 2
Displaying Chart on Userform (with Scroll Bars) 3
Need Help with Print Out of Userform 1
Printing Userform w/ Printer Selection 2
Printing Contents of UserForm 1
Running macro automatic after opening Userform 4

Top