Printing userforms

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

[Excel 2003]

I use userforms for entering and displaying data.

How can one print the contents of a userform - also print it if it covers
several pages (I use scroll bars on the form as it is larger than the page)

Can anyone help with suitable advice, links or code?

best regards,

Roger
 
See "PrintForm" method in VBA help file. It appears that this method will
only print the visible portion of the form. You would have to use
additional code to scroll the form and do additional print to capture the
entire form.
 
Back
Top