User form - print Landscape

  • Thread starter Thread starter Priya Menan
  • Start date Start date
P

Priya Menan

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Userforms [Landscape] 1
How to set PrintSetup? 8
Printing userform in landscape on one page only 2
Printing the selected sheets 3
Print Landscape AND Portrait Orientation in ONE Worksheet 0
Zoom to fit Columns 4
Excel VBA - Problem with Closing Print Preview 0
Getting a "File Not Found" error when trying to show userform 1

Back
Top