View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Printing form & contents

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