View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Priya Menan Priya Menan is offline
external usenet poster
 
Posts: 1
Default 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 ***