vba to print Form from Excel ?

I've got a for for entering data into a spreadsheet.

Can you print the Form as it is using Excel VBA ?

If so, any code snippits that may give me the idea?

thanks for any help.

tmb

You can use the PrintForm method:

Private Sub cmdPrint_Click()
frmOrders.PrintForm
End Sub


tmb wrote:
> I've got a for for entering data into a spreadsheet.
>
> Can you print the Form as it is using Excel VBA ?
>
> If so, any code snippits that may give me the idea?
>
> thanks for any help.
>
> tmb
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html