Printing VB Userform in Excel

[Siddharth Rout]

Hi

i want to print the userform created in excel. the command that i am using is

userform.printform

the problem is that the userform is so big that it is not fitting in one page. is there any way i can change the orientation to 'landscape' (using vbcode) and then take a print of the current userform??? or is there any other way to print it?

thanks

more info: the height of userform is 405 and width is 725. there is a commandbutton in the userform that uses the above code to print the userform. it does print perfectly. it's just that it takes two pages to print...

[RobDog888]

There is no standard support for this bt you may be able to work around it by using some APIs like BitBlt to resize the image and fit it to a single page. I am not familiar enough with it to provide an example but here is a link for the API.

http://www.allapi.net/apilist/BitBlt.shtml

[Siddharth Rout]

thanks rob

i visited the site but everything went qbove my head

so i tried the most common way. i simply typed "printing userforms in excel" in google and searched. i was surprised by the links it pulled up. seems like i am not the only one who is facing this problem

anyways i just had a thought. i am not sure if this is possible.... can we change the orientation on the printer properties in Control Panel|Printer to landscape and back to potrait through VB code????

I am sure there definitley has to be a way....

I am still searching the web. in case i come across anything, i'll definitely update this thread...

Thanks once again...

[Siddharth Rout]

I JUST FOUND SOME THING THAT MIGHT HELP....

WILL GIVE IT A TRY AND SEE IF IT WORKS....

http://groups.google.com/group/micro...652a998c2a44c4