Printing User Forms

  • Thread starter Thread starter mickiedevries
  • Start date Start date
M

mickiedevries

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

Thanks

Micki
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Word document reporting 3
Loop & Print 17
How to print multiple sections from different worksheets 1
Copy or Print from User Form? 2
Macro to select, set, and print 12
Frame captions aren't printing when the userform is printed 2

Back
Top