Printing one worksheet from another

[Thespiv]

I know how to add a button to a form and I also know how to print the form being viewed, but I can't figure out how to insert a button which will print a different form. The user form I have basically adds data to a second Printed version, I only want the printed version to be printed from my button in the user form.

 

[Thespiv]

Just Dragging this to the top of the list incase the guy who has the answer is now up and about

 

[Dave Hawley]

Hi

If the UserForm you want printed is called UserForm 1, just use:

Private Sub CommandButton1_Click()
UserForm1.PrintForm
End Sub

On the other UserForm

 

[Thespiv]

Hey Dave thanks for the advice, Little green around the visual basic stuff, I kinda guessed a little and camr up with this syntex from yours:
Private Sub CommandButton1_Click()
risk_assesment_form.PrintForm
End Sub.
saved the file, closd it, re-opened it, and alas it didnt work, any suggestions where things might be going wrong?

 

[Thespiv]

Still not solved

 

[Thespiv]

bringing it back to the top to in the hope that someone wiil be kind enough to solve this problem

 

[Thespiv]

keeping this on top cos i really need an answer!

 

[Anne Troy]

Did you create a command button for that code to work? WHEN do you want that form to print? When you open the file, when you click a button, when?

 

[Thespiv]

I used the forms tool bar to create the button, I want the form to print when the user click on the button, I iserted a button so as the user could simply print the form when they had completed their inputting. would one normally create a button if you wanted the form to print on open?
This message was edited by Thespiv on 2002-03-04 11:14