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

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.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

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

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!