UserForm - Print out - with Data

[Philcjr]

Curious question: Is there a way (easy or complex) to have the ability to print a out a userform with its populated data?

Userform populates with data that is in a spreadsheet, there are pull-downs, textboxes, radio buttons... and the like.

The goal would be to be able to press a print-command button and have the userform with its data print to the default printer.

I have search high and low for any kind of help online with no success. Might be a good KB entry???:dunno

Thanks,
Phil

[johnske]

Hi Phil,

in 2000
UserForm1.PrintForm and in 97 I'm pretty sure I used to use
UserForm1.Print

[Philcjr]

WOW :bow:

That seems so easy :)

I will test and report back

Thanks