Solved

Print a long Userform in Excel

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now