Printable View
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
Welcome to the forums. :wave:
On what line does the error occur?
.PageSetup.Orientation = xlLandscape
thanks
.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.
Moved to Office Development
hmm thank you