[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Print a long Userform in Excel

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
85521
Asked:
85521
  • 2
  • 2
1 Solution
 
SafetyFishCommented:
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
 
NorieVBA ExpertCommented:
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
 
85521Author Commented:
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
 
NorieVBA ExpertCommented:
Arno

It shouldn't be too hard.

What do you have on the userform and how do you need it printed?
0
 
85521Author Commented:
Even if no solution is not satisfying it is good to know that searching forward is useless. Thanks
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now