Hi Mully,

Thanks for prompt answer - however I may have phrased the query wrong. I can
get the user form to print when I open it in VBA mode with the statement
UserForm1.PrintForm but when the User Form opens in Excel sheet ( Customers )
and all their details enter the various boxes for that particular customer it
will not print that user form with the customers details. Does that explain
it better???

It works fine for me. I just tried by using a simple form with a button and an
editbox with the following code attached to the button:

Private Sub CommandButton1_Click()
Me.PrintForm
End Sub

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com