Printing VB Userform in Excel
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...
Re: Printing VB Userform in Excel
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
Re: Printing VB Userform in Excel
thanks rob
i visited the site but everything went qbove my head :blush:
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 :lol:
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...
Re: Printing VB Userform in Excel
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