Print Form???

[davidgottlieb]

Hi. I have a user form in Excel. What is the code to print the form in VBA???


Thanks

[Syl]

Hi,
try to use PrintForm method:

YourFormName.PrintForm

Here's it's description from MSDN:

Sends a bit-by-bit image of a Form object to the printer.

Syntax

object.PrintForm

The object placeholder represents an object expression that evaluates to an object in the Applies To list. If object is omitted, the Form with the focus is assumed to be object.

Remarks

PrintForm prints all visible objects and bitmaps of the Form object. PrintForm also prints graphics added to a Form object or PictureBox control at run time if the AutoRedraw property is True when the graphics are drawn.

The printer used by PrintForm is determined by the operating system's Control Panel settings.