Printing a userform and displaying a chart upon finish VBA program

[damayn83]

I am trying to print the data that was used as input for the userform and display results on a chart. I have created the chart already. The userform has too much information to remember and I would like it to be automatically printed upon completion of the code. I have a message box that pops up when the code is done running. Once you click "Ok", the userform should be printed and the chart displayed.

Here is the code for the message box:

Please Login or Register  to view this content.

Instead of the program ending, the following actions should take place.

[jaslake]

Hi damayn83

I can show you Code to do a Print Preview of your UserForm

Please Login or Register  to view this content.

And I can show you Code to save the UserForm to a PDF

Please Login or Register  to view this content.

And I can show you Code to Print your UserForm

Please Login or Register  to view this content.

Can't help you implement without seeing what you have and what you're trying to do.

[damayn83]

jaslake, does all the code need to be put into vba or just what I specifically need?

[damayn83]

jaslake, "keybd_event" is not recognized. When I use the help function, nothing comes up. Why?

[jaslake]

Hi damayn83

I can tell you how I've implemented this Code

Please Login or Register  to view this content.

The Code lives in the UserForm Module and is assigned to my OptionButton2. I click on the Button and it goes to print Preview. If you were to change this line of Code it'll go to the Printer

Please Login or Register  to view this content.

I do have these References set
References.jpg

And this is how the Final Product looks
frmSummary.jpg

Without seeing what you have and what you're trying to do, I can't implement it for you.

[damayn83]

Okay, I need a print out button on my userform that is a click style. Think I have it.

[jaslake]

Hi damayn83

I'd think that should do it...let me know how you make out.

[damayn83]

It is creating a new workbook and not printing the userform. I am still playing around with the code to get it to work correctly. Can I make your code print out specific worksheets that I have created?

[damayn83]

I had to change your code a little bit once I figured out what it was doing. It now prints out the active worksheets in the workbook at end of program. Here is what it look like now. Thank you for all your help, could not have done it with out you.

Please Login or Register  to view this content.

[damayn83]

I had to change your code a little bit once I figured out what it was doing. It now prints out the active worksheets in the workbook at end of program. Here is what it look like now. Thank you for all your help, could not have done it with out you.

Please Login or Register  to view this content.

[jaslake]

Hi damayn83

Good for you...glad you got it sorted. Glad I could help...you're welcome.