请教老师:如何修改以下代码,实现打印预览?我改为了printpreview,测试不行
Sub DY()
On Error GoTo 10
Sheet1.PrintOut Copies:=选择.TextBox1.Value * 1
JL
With 选择.ListView1
For i = 1 To .ListItems.Count
If .ListItems(i).Checked = True Then
Sheet1.Range("A4") = .ListItems(i)
Sheet1.Range("E6") = .ListItems(i)
Sheet1.Range("c15") = .ListItems(i).SubItems(2)
Sheet1.Range("b6") = .ListItems(i).SubItems(3)
Sheet1.Range("b7:e7").ClearContents
.ListItems(i).Checked = False
'Sheet1.Range("B6") = ""
Exit Sub
End If
Next
MsgBox "打印完毕!"
Unload 选择
End With
Exit Sub
10 Sheet1.PrintOut
JL
MsgBox "打印完毕"
End Sub