vba 打印窗体内容？

Question

vba 打印窗体内容

Answer 1

Sub printSheets()
Application.Dialogs(xlDialogPrint).Show
Sheets("Form").Range("CA2:CA27").ClearContents
End Sub

Private Sub CommandButton1_Click()
Call printSheets
End Sub