Printing A form
Posted on 2004-04-29
Hi, i am using VB for applications in Excel. I have a program with which i would like to print the form. I have had no hassle doing so by using the printform command but what i would like to do is have the "Report" that it prints in the center of the screen. Is this possible with VBA as i found it very simple using VB6.
Here is what i would normally use
printer.CurrentX = (printer.Width - Editscreen.Width) / 2
printer.CurrentY = (printer.Width - Editscreen.Width) / 2
When i take out the "printer....." lines it works fine but surprise surprise when i try to use them i get an error.
This is probably a very simple question and the answer is probably No you can't do it, but if i get an answer that says i can i will give out 125 points. If the answer is just no then it'll be a 50.