Printing User Forms

M

mickiedevries

How do I print a user form? I know how to print a worksheet but not
user form.

Thanks

Micki
 
C

Charles

mickiedevries


If you add a command button on your userform you can use

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

Or:

Sub printuserform()
UserForm1.PrintForm
End Sub


This should print the form.

Charle
 
C

Charles

mickiedevries


If you add a command button on your userform you can use

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

Or:

Sub printuserform()
UserForm1.PrintForm
End Sub


This should print the form.

Charle
 
C

Charles

mickiedevries


If you add a command button on your userform you can use

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

Or:

Sub printuserform()
UserForm1.PrintForm
End Sub


This should print the form.

Charle
 
C

Charles

mickiedevries


If you add a command button on your userform you can use

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

Or:

Sub printuserform()
UserForm1.PrintForm
End Sub


This should print the form.

Charle
 
C

Charles

mickiedevries


If you add a command button on your userform you can use

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

Or:

Sub printuserform()
UserForm1.PrintForm
End Sub


This should print the form.

Charle
 
C

Charles

mickiedevries


If you add a command button on your userform you can use

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

Or:

Sub printuserform()
UserForm1.PrintForm
End Sub


This should print the form.

Charle
 
C

Charles

mickiedevries


If you add a command button on your userform you can use

Private Sub CommandButton4_Click()
UserForm1.PrintForm
End Sub

Or:

Sub printuserform()
UserForm1.PrintForm
End Sub


This should print the form.

Charle
 
Top