Save userform as a PDF

[Rodrigues]

Hi all
I'm using attached code to save a userform into a pdf, the problem is that, is converting the excel data into excel. I'm wondering if it is possible to save the userform as it is, either when click on "Command Button1" save as or automatically with number of the "Ref" field.
For this to work

Sheet1.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\PDF\Book1.pdf", Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, IgnorePrintAreas:=True, OpenAfterPublish:=False
     
Unload UserForm1
End Sub

have created a folder on my C drive called PDF.
Many thanks in advance
Regards
R

 

[Chihiro]

Userform can't be saved as PDF directly.

You just need to build Excel Sheet to mimic Userform and save as PDF.

However, if you want interactive form on PDF, you'd need to do it from Acrobat side and you'd need licensed version of Acrobat (Payed) or other third party software.

 

[vletm]

You could try to use Me.PrintForm with Your CommandButton
and after that
it would be possible to Save As PDF too.

Private Sub CBtn_Click()
    Me.PrintForm
End Sub

 

[Rodrigues]

Thanks all, much appreciated.