Printing a VBA Form in Excel
 

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.

Printing a VBA Form in Excel
 

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



wrote in message om...
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.