Printing userforms

[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

 

[JLGWhiz]

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.

 

[Gord Dibben]

FastStone Capture utility will capture a scrolling screen.

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


Gord Dibben MS Excel MVP