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
