VB Excel Userform - print in Landscape

[pretty gal]

Hello

I am having trouble printing my user form in landscape view. here is my code...
Private Sub cmdPrint_Click()
With InputForm
.PageSetup.Orientation = xlLandscape
.PrintForm
End With
End Sub


"Method or Data member not found" this is the error message i am getting..

thank you in advance...

Pretty Gal

[Hack]

Welcome to the forums.

On what line does the error occur?

[pretty gal]

.PageSetup.Orientation = xlLandscape
thanks

[Chrissy]

.pagesetup.orientation does not belong to a form object, only a worksheet object. I don't believe you can adjust the orientation when printing the user form.

[Hack]

Moved to Office Development

[pretty gal]

hmm thank you