Print Active Form

[Nomis_Eswod]

Hi,

I want to do a macro that will print forms that I have created in Excel. However, instead of doing a macro for each form, I was wondering if there was a way to print the active form, whichever one it is. So was thinking something like

Sub Print()
ActiveForm.Print
End Sub

That doesn't work, so wondered if there was anyway of doing this?

 

[Norie]

By forms do you mean userforms?

 

[Andrew Poulsom]

This:

Me.PrintForm

will print a UserForm if it's in the UserForm's code module.

 

[Norie]

If there is only 1 userform active try this.

UserForms(0).PrintForm

 

[Nomis_Eswod]

Excellent, thanks!

Went for the Me.PrintForm in the end!

 

[radlernyc]

Is there a way to format the form for printing (i.e Fit to page, landscape).

 

[radlernyc]

bump