Hi,
I have a userform which is longer than the standard dimensions for using the printform command function.
I already have a command button which can take a print screen of the userform and send it to a word document, but from experience the users of this userform will not use that function and would prefer the direct print option.
Even though the userform is long, I only need to print a specific area of the form and was wondering if there was a way to use a command button to automatically change the scrolltop property of the form (or just move the scrollbar position to near the top), and then use the printform function after.
The scrollbar isn't one from the toolbox but instead the builtin userform scrollbar from the properties window.
Example userform attached.
I appreciate any help you can give.
Thanks,
Bookmarks