MrExcel.com - Your One Stop for Excel Tips & Solutions

Printing a UserForm

Posted by Stan on November 23, 2001 10:10 AM

Is it possible to print a UserForm in VBA through, say, a Command button?

Stan

Posted by Juan Pablo on November 23, 2001 11:22 AM

Try with

Private Sub CommandButton1_Click()
UserForm1.PrintForm
End Sub

Posted by Stan on November 23, 2001 11:39 AM

Thanks Juan!