View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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