i want to print the userform created in excel. the command that i am using is
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?
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...
Last edited by Siddharth Rout; May 3rd, 2006 at 08:38 AM.
Reason: more info added
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.
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...