So how would I go about this? At the moment, I've got a massive
UserForm1_Initialize script that goes through and collects all the
information that needs to be on the form. I'd prefer to create a new sub to
run on the print button. I want it to create a new sheet with columns A, B,
C, and D each having a header cell with the category they represent, then
their contents below. Then, I'd like to print the worksheet and delete it
from the workbook.

I'm not sure where to start. Can someone please help get me started?



"Dave Peterson" wrote:

How about just dumping the lists to a new worksheet and printing that.



AB wrote:

To clarify, I have already tried UserForm1.PrintForm, which does a fine job
of printing the form.

However, on the form I have three list boxes with order numbers that have
been flagged for review. The printing doesn't let you see what is scrolled
down the listbox.

More than anything, I'd like to print the information dumped into the
listbox and a column header. There are other items on the form that would be
nice to have, but not critical.

"AB" wrote:

I've created a form that populates some fields with flagged items from my
spread sheet.

How do I get my print button to print the items listed on the form?

--

Dave Peterson