|
设计了一个窗口,如图:
如何能当用户不勾选时,将sheet10,sheet3和sheet4打在同一个pdf文档中
如果勾选了就再相应增加(勾选第四个则sheet1也打印,勾选第五个则sheet5打印)
我写的:
Private Sub CommandButton2_Click()
Dim shprinte As Worksheets
If CheckBox4.Value Then
If CheckBox5.Value Then
shprinte = Sheets(Array("sheet10", "sheet3", "sheet4", "sheet1", "sheet5"))
Else
shprinte = Sheets(Array("sheet10", "sheet3", "sheet4", "sheet1"))
End If
ElseIf CheckBox5.Value Then
shprinte = Sheets(Array("sheet10", "sheet3", "sheet4", "sheet5"))
Else
shprinte = Sheets(Array("sheet10", "sheet3", "sheet4"))
End If
shprinte.Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "\" & TextBox1.Text & "Résultats.PDF", openafterpublish:=True
Load Me
End Sub
但是总是提示shprinte这个句子有问题,问什么?
谢谢!
学习了,方法不错。 - Private Sub CommandButton2_Click()
- Dim shprinte As object
- If CheckBox4.Value Then
- If CheckBox5.Value Then
- Set shprinte = Sheets(Array("sheet10", "sheet3", "sheet4", "sheet1", "sheet5"))
- Else
- Set shprinte = Sheets(Array("sheet10", "sheet3", "sheet4", "sheet1"))
- End If
- ElseIf CheckBox5.Value Then
- Set shprinte = Sheets(Array("sheet10", "sheet3", "sheet4", "sheet5"))
- Else
- Set shprinte = Sheets(Array("sheet10", "sheet3", "sheet4"))
- End If
- shprinte.Select
- ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "" & TextBox1.Text & "Résultats.PDF", openafterpublish:=True
- Load Me
- End Sub
复制代码
|
|