Solved

Print a long Userform in Excel

Posted on 2011-09-13
5
395 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 34

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 34

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

729 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