Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel User form - print landscape
what line is the code breaking on?
pagesteup.orientation or printform ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Landscape | Excel Discussion (Misc queries) | |||
User form - print Landscape | Excel Programming | |||
Print Excel Form In Landscape Mode? | Excel Programming | |||
Printing a user form landscape | Excel Programming | |||
print a form landscape | Excel Programming |