Excel User form - print landscape
 

hello,
Happy new Year


I am having trouble printing my user form in landscape view. here is m
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 a
getting..

thank you in advance...

Prett

--
pretty ga
-----------------------------------------------------------------------
pretty gal's Profile: http://www.hightechtalks.com/m66
View this thread: http://www.hightechtalks.com/t232395

Excel User form - print landscape
 

what line is the code breaking on?
pagesteup.orientation or printform ?

Excel User form - print landscape
 

You have 2 problems. There is no PageSetup property of a
userform, so get rid of that line. Next, you're missing the
leading period before PrintForm.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"pretty gal"
wrote in message
...

hello,
Happy new Year


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


--
pretty gal
------------------------------------------------------------------------
pretty gal's Profile: http://www.hightechtalks.com/m661
View this thread: http://www.hightechtalks.com/t2323959

Excel User form - print landscape
 

You got a reply to your post in .programming.

pretty gal wrote:

hello,
Happy new Year

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

--
pretty gal
------------------------------------------------------------------------
pretty gal's Profile: http://www.hightechtalks.com/m661
View this thread: http://www.hightechtalks.com/t2323959

--

Dave Peterson