Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Form to Include All Options in Excel | New Users to Excel | |||
stop form printing | Excel Discussion (Misc queries) | |||
printing onto re printed form | Excel Discussion (Misc queries) | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) | |||
Printing A Form | Excel Programming |