?
Solved

Print a long Userform in Excel

Posted on 2011-09-13
5
Medium Priority
?
433 Views
Last Modified: 2012-08-14
Hi,

I have a userform with scrollbars in Excel which is created in runtime. Unfortunately this userform can conditionally be very long. If I use PrintForm only one page is printed and the part which is to long for the first page is ommitted. Is there a way to print the whole userform, even if it would take two or three pages?

Thanks, Arno
0
Comment
Question by:85521
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:SafetyFish
ID: 36529159
From doing a little quick searching, it seems to me that this functionality does not exist (or is very well hidden).

As another alternative, would it be functional for you to move the position of the scroll bar in-between printing? If so, this might help you:

http://www.accessmonster.com/Uwe/Forum.aspx/access-forms/48304/Moving-a-scroll-bar-with-VBA

0
 
LVL 37

Accepted Solution

by:
Norie earned 1500 total points
ID: 36529417
Arno

Printing userforms is always problematic and, to me anyway, they don't look too good anyway.

Also, different printers, different print setups.

So if you do find something that works on one printer it's not guaranteed to give the same results on another.

Can't you just transfer the data to a worksheet and print that?

0
 

Author Comment

by:85521
ID: 36532589
Hi imnorie,

I did like to circumvent to put the layout into a worksheet (it was hard work). But it seems that there is no way to go around this :-(

Thanks, Arno
0
 
LVL 37

Expert Comment

by:Norie
ID: 36533009
Arno

It shouldn't be too hard.

What do you have on the userform and how do you need it printed?
0
 

Author Closing Comment

by:85521
ID: 36813044
Even if no solution is not satisfying it is good to know that searching forward is useless. Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question