Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a visual basic form fill a page
How do I apply this to a form though?
"NickHK" wrote: There's a function "CentimetersToPoints" which will tell you the required dimensions of the form to fit an A4 page. NickHK "HFB" wrote in message ... Hi How do I make a form that will fill an A4 page when printed (portrait layout) ta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a visual basic form fill a page
Something like: sngWidthOfA4=21.0 FormA4.Width=Application.CentimetersToPoints(sngWi dthOfA4) Remember that each printer has a border to which it cannot print. You will have to test your set up to find the printable area (or use some pretty complex API calls) NickHK "HFB" wrote in message ... How do I apply this to a form though? "NickHK" wrote: There's a function "CentimetersToPoints" which will tell you the required dimensions of the form to fit an A4 page. NickHK "HFB" wrote in message ... Hi How do I make a form that will fill an A4 page when printed (portrait layout) ta |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a visual basic form fill a page
Ended up just finding the height property in the forms box and playing with
that until it printed out how I wanted. For future reference: A4 - Height is 833.25 points, width is 576 points (approx) Am using a scrollbar to enable user to view whole form on screen. Thanks "NickHK" wrote: Something like: sngWidthOfA4=21.0 FormA4.Width=Application.CentimetersToPoints(sngWi dthOfA4) Remember that each printer has a border to which it cannot print. You will have to test your set up to find the printable area (or use some pretty complex API calls) NickHK "HFB" wrote in message ... How do I apply this to a form though? "NickHK" wrote: There's a function "CentimetersToPoints" which will tell you the required dimensions of the form to fit an A4 page. NickHK "HFB" wrote in message ... Hi How do I make a form that will fill an A4 page when printed (portrait layout) ta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
visual basic help Excel/word form filling in | Excel Discussion (Misc queries) | |||
Visual basic, form does not show date correctly.... | Excel Worksheet Functions | |||
visual basic user form date format dd/mm/yy not mm/dd/yy | Excel Discussion (Misc queries) | |||
Make a Excel Chat through Visual Basic 6.0 | Excel Programming | |||
Using Visual Basic form to enter data | Excel Programming |