Print current records from userform on sheet

[swiftrain]

Is there a way to have a "print" button on a userform and when clicked, it exports the active data to a formatted sheet and then it prints the sheet? I have a multipage userform and "printform" would not work. Once the data is printed it would have to be cleared from the sheet.

Thank you,

[swiftrain]

It has been a few days, does anyone have any information on this? Even a link to where I could start looking would be helpful.

[jwright650]

I've created several...let me look back through my old postings and see if I can find an example for you.

BTW, the forum seems very busy these days so don't feel too overlooked....I've had a thread out there since March and I'm the ONLY person posting in it. I suppose everyone is too busy to help these days.

BRB

[jwright650]

I just went through all of my old postings and found a few examples, but I don't want to quickly post up and then it not work for you.

Can you attach an example worksheet file with some dumby data? Include the correct sheet formatting on the sheet that you want to print, and make sure it has the userform with a command button in there.
-just some sample file or a file with all sensitive data taken out will do

Reason is all of the code that I have, or have written, was very sheet or workbook specific and would take considerable time to edit to make it work with another workbook. I don't mind helping, but I don't have anyway for getting started to make sure it works correctly on your workbook.

[swiftrain]

Here is a sample Workbook.

Sample IIS.xlsm

[jwright650]

For some reason there are a couple items missing and it doesn't run on my machine. Does the userform send the data to the worksheet correctly in your working workbook?

You just want to be able to print the userform with all of the fill boxes filled in, and then clear the userform's fill boxes to log a new incident?

[jwright650]

OK I commented out the call to the calendar and was able to get the userform to work, and it does copy the data to the worksheet(database).

So it seems the wookbook runs OK, but if I understand you correctly, you want to print the userform with all of the info filled in, after printing then clear it out so you can start over? Keep in mind that there are multiple userforms associated with the main userform.

[jwright650]

Your PrintForm cmdbutton works and prints the userform, but it doesn't print each of the 3 pages on the multi-page item that is on the userform. The only page that you can see on the printjob is the page that is on top at the time that you hit the cmdbutton. I'm not sure how to handle that one. Still playing with it...for now.

[swiftrain]

I would like to print everything from the current userform.

Unless there is a way to create another userform (button on spreadsheet maybe), have it find the "reference #" then print the information in that corresponding row.

[jwright650]

I would like to print everything from the current userform.

Unless there is a way to create another userform (button on spreadsheet maybe), have it find the "reference #" then print the information in that corresponding row.

Is that sheet named "Form", or is that what you are trying to fill in with the information from the userform? I think we can set up your new sheet "Form" to populate from the refrence number. ie type in the reference number and have the rest populate itself from the information on "Sheet1".
I gotta run pick up the kids from school, but I can help you work on this on again on monday, if you haven't gained any ground on it by then. Have a great weekend.

[jwright650]

Any progress on your worksheet over the weekend? Just wondering...if I get a few minutes today, i'll try to work it it some more once I figure out exactly what you want to accomplish when you hit this "print" button.
post back in here and let me know if you still need some help or if you got it figured out.

[swiftrain]

Thanks for keeping up with it. I am still trying to figure it out on this spreadsheet. All I need is for the active data on the userform to print in the format chosen on a worksheet.

Someone had mentioned to create another form and format it to "look" like a report to print and then use "printform". I would then have a button to open the other