excel vba print

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA - Print a Userform

Excel VBA - Print a Userform

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips


Server loaded in 0.08 secs.