[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.


"Roger on Excel" wrote in message
...
[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

FastStone Capture utility will capture a scrolling screen.

http://www.faststone.org/FSCaptureDetail.htm


Gord Dibben MS Excel MVP

On Mon, 23 Nov 2009 15:01:02 -0800, Roger on Excel
wrote:

[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