Printing userforms
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
|