User form - print Landscape
 

how do i print my userform in landcape.
here is my code

Private Sub cmdPrint_Click()
With InputForm
..PageSetup.Orientation = xlLandscape
..PrintForm
End With
End Sub

I am getting an error saying "object required"

Thank you in advance..

Priya

*** Sent via Developersdex http://www.developersdex.com ***

User form - print Landscape
 

Jim Rech posted this:
http://groups.google.co.uk/group/mic...ecede71e783f53

or
http://snipurl.com/lasc

Priya Menan wrote:

how do i print my userform in landcape.
here is my code

Private Sub cmdPrint_Click()
With InputForm
PageSetup.Orientation = xlLandscape
PrintForm
End With
End Sub

I am getting an error saying "object required"

Thank you in advance..

Priya

*** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson