Excel User form - print landscape

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

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

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

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