Solved

Print a long Userform in Excel

Posted on 2011-09-13
5
388 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 33

Accepted Solution

by:
Norie earned 500 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 33

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

749 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