I want to Print the userform

[lovejanu4u]

I am finding confused for printing the userform.

Please help for creating excel VBA code for printing userforms.

 

[DanteAmor]

Try this

Me.PrintForm

Or

Private Sub CommandButton1_Click()


    Set h1 = Sheets.Add
    h1.PageSetup.Orientation = xlLandscape
    Application.SendKeys "(%{1068})"
    DoEvents
    h1.Paste
    h1.PrintOut Copies:=1, Collate:=True
    Application.DisplayAlerts = False
    h1.Delete
End Sub

 

[lovejanu4u]

Do i need to apply the userform page setup
as I got printout but with the code only.

Try this

Me.PrintForm

Or

Private Sub CommandButton1_Click()


    Set h1 = Sheets.Add
    h1.PageSetup.Orientation = xlLandscape
    Application.SendKeys "(%{1068})"
    DoEvents
    h1.Paste
    h1.PrintOut Copies:=1, Collate:=True
    Application.DisplayAlerts = False
    h1.Delete
End Sub

 

[lovejanu4u]

Aslo can anyone share how to code VBA excel to page setup of userform

Do i need to apply the userform page setup
as I got printout but with the code only.

 

[DanteAmor]

What do you mean by the "page setup"

Your userform contains multipage. It has something to do with

I want to Print the userform