To print a userform

**funkymonkUK** · 05-04-2005, 06:58 AM

Hi

What I am trying to do is make my workbook based on a userform is there a way that once a user has completed the information that they have entered can they print the userform with all the data added to it. I have multiple entries. I have a sheet which all the information is stored under. What I want is to be able to select a month that was entered and then print off all the details of the stuff that was entered in.

Any ideas??

**funkymonkUK** · 05-05-2005, 05:54 AM

CAN someone not help me??

**funkymonkUK** · 05-05-2005, 07:22 AM

13 views and nobody can help me??

if there can someone at least say something.

**Leith Ross** · 05-05-2005, 07:32 AM

Hello Funkymonk,

Neither Excel or VBA directly support printing of User Forms. It can be done. I will have to do a little research on it though. I rememeber it involves several API calls to get the job done. You may be able to track it down yourself on Google. In the mean time, I will look into it, and post what I find.

Sincerely,
Leith Ross

**funkymonkUK** · 05-05-2005, 08:59 AM

Thanks Leith I managed to find something like the below

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

I have also attached the definition for anybody. Only problem is how do I specify whether I want the page to print Landscape or Portrait?

Below is the definition

PrintForm Method
Applies To

UserForm object.

Description

Sends a bit-by-bit image of a UserForm object to the printer.

Syntax

object.PrintForm

The object placeholder represents an object expression that evaluates to an object in the Applies To list. If object is omitted, the UserForm with the focus is assumed to be object.

Remarks

PrintForm prints all visible objects and bitmaps of the UserForm object. PrintForm also prints graphics added to a UserForm object.

The printer used by PrintForm is determined by the operating system's Control Panel settings.

Example

In the following example, the client area of the form is printed when the user clicks the form.

' This is the click event for UserForm1
Private Sub UserForm_Click()
UserForm1.PrintForm
End Sub

Hope we can solve this problem together. let me know thanks

**funkymonkUK** · 05-05-2005, 09:21 AM

**Leith Ross** · 05-05-2005, 10:01 AM

Hello FunkyMonk,

That you for that post. I learned an easier way to do it. My apologies for stating that VBA did not a method of printing out the form. Good job!

Sincerely,
Leith Ross

**funkymonkUK** · 05-06-2005, 04:01 AM

anybody know how to change the page layout with this code?

**funkymonkUK** · 05-06-2005, 07:57 AM

how do I specify whether I want the userform to print Landscape or Portrait?

**mangesh_yadav** · 05-06-2005, 08:25 AM

There is no option for the layout in the VBE's print function. So i guess this will have to be set through the printers default layout setting

- Mangesh