Printing User Forms
 

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

Thanks

Micki

--
Message posted from http://www.ExcelForum.com

Printing User Forms
 

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

--
Message posted from http://www.ExcelForum.com

Printing User Forms
 

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

--
Message posted from http://www.ExcelForum.com

Printing User Forms
 

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

--
Message posted from http://www.ExcelForum.com

Printing User Forms
 

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

--
Message posted from http://www.ExcelForum.com

Printing User Forms
 

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

--
Message posted from http://www.ExcelForum.com

Printing User Forms
 

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

--
Message posted from http://www.ExcelForum.com

Printing User Forms
 

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

--
Message posted from http://www.ExcelForum.com