Print preview in a user form

[Scott]

Does anyone know if you can poulate a user form within
excel with Print preview?

I have a user form that once updated creates an invoice
and so I would like a picture of the invoice next to the
ser form.

Can this be done?

Scott

 

[Dick Kusleika]

Scott

I don't think so. Do you have Adobe Acrobat such that you could print the
invoice to a pdf? If so, you could show the pdf using the WebBrowser
control, then delete the pdf when you close the form.

 

[Scott frisby]

I dont think using Adobe would work as the user can scroll through
transactions and the invoice in the preview box would need to update as
the transaction line was selected.

I think the best way round this is to create a user form that looks
similar to the invoice as this could easily be updated quickly with the
information and could be used as a preview.

Thank you for your help

Scott