Mark -

How does the form fit on the screen, if it's three printed pages long?

I had to do a similar thing for a client, with a long form that was
complicated by having controls in a viewing area that scrolled up and
down, into and out of view. I had to scroll to the top of this area,
take a screen shot, then scroll the area down, and take screen shots
until the entire form had been captured. Then I had to cut the images
up, I pasted them into a worksheet like a puzzle, and printed out the sheet.

I had to use a bunch of APIs, and I think I eventually had to save the
image in a bmp file and then insert it into the worksheet. My code was
based partly on MS KB articles 161299 and 230502, this web page

http://www.lebans.com/imagecontroltoclipboard.htm

and a post by Mike Sutton, headed "Copy a Picture to the Clipboard
API/VBA", in the microsoft.public.vb.winapi.graphics newsgroup. Plus
lots of trial and error.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


V-Man wrote:

I want to print a rather long userform that I have created. However,
when I use the ".printform" command, Excel only prints one page of my
userform (it should be around 3 pages in length).

How do I print the entire length of my userform? I know a VBA screen
capture may work, but how do I code it so that I can print the entire
3-page userform?

Thanks for the help,

Mark