Printing a VBA Form in Excel

  • Thread starter Thread starter crookie74
  • Start date Start date
C

crookie74

I have set up a series of forms, the last of which displays all the
details the user has put in. I would like to put a button on this form
to print the whole form but unsure how to do this. I know I could just
set up a macro to copy all the details into a workbook and then print
out but I thought if I could print the form it would be neater.

Can anyone please help me?

Thanks,
Crookie.
 
Hi Crookie

If you want to print the Userform you can add this code to a button on the userform

Private Sub CommandButton1_Click()
Me.PrintForm
End Sub
 
Back
Top