98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA - Print a Userform
Excel VBA - Print a Userform
Resolved · High Priority · Version 2003
Marta has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA - Print a Userform
Hello,
I have created a User Form that contains 22 fields with information. I have added some command buttons such as Close and Print.
The Print button is working but the print does not show all the information contained in the User Form, only part of it.
The current code for the Print command button is:
Private Sub CommandButton5_Click()
PrintForm
End Sub
I have been trying to add more code (page set up, properties...) so that I can print properly the whole User Form.
So far nothing seems to work!
Any ideas?
Many thanks in advance.
Regards
RE: Excel VBA - Print a Userform
Hi Marta
Thanks for your question
First, apologies for the delay in getting back to you. We have ha very heavy traffic on the forum and we are now starting to clear thew backlog
Your question is a little difficult to answer without seeing all the code and the form. If your question hasn't already been answered could you possibly email me the file in question and I will give it my urgent attention
my email is stephen@stl-training.co.uk
Regards
Stephen
RE: Excel VBA - Print a Userform
Hi Marta,
How are you?
Did you manage to get a copy of your workbook or example dummy file over to Stephen for him to have a look at?
This question has now been left unattended for a while.
We like to keep down the large number of active forum posts we receive.
As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).
We look forward to hearing from you.
Thank you.
Regards, Rich
Wed 20 May 2009: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Freeze Rows and Columns to keep lables displayedYou can freeze rows and columns in your worksheet so they don't move. |