|
本帖最后由 hiyou 于 2014-7-22 09:18 编辑
赋值部分,前面两个标红的错句给你示例,最后一个自已试试.
就是在引号部分断开,用 chr(34) & "内容" & chr(34) 代替- strproc = "Private Sub checkbox1_Click()"
- strproc = strproc & vbCrLf & "Dim BJ()"
- strproc = strproc & vbCrLf & "Dim i As Intege"
- strproc = "Private Sub checkbox1_Click()"
- strproc = strproc & vbCrLf & "Dim BJ()"
- strproc = strproc & vbCrLf & "Dim i As Intege"
- strproc = strproc & vbCrLf & "BJ = Array("
- strproc = strproc & vbCrLf & Chr(34) & 3001 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3002 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3003 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3004 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3005 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3006 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3007 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3008 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3009 & Chr(34) & ","
- strproc = strproc & vbCrLf & Chr(34) & 3010 & Chr(34)
- strproc = strproc & vbCrLf & "On Error Resume Next"
- strproc = strproc & vbCrLf & "If CheckBox1.Object.Value = True Then"
- strproc = strproc & vbCrLf & " For i = 1 To UBound(BJ)"
- strproc = strproc & vbCrLf & " With ActiveSheet.PivotTables("
- strproc = strproc & Chr(34) & "PivotTable1" & Chr(34) & ").PivotFields("
- strproc = strproc & Chr(34) & "T" & Chr(34) & ")"
- MsgBox strproc '<==这个句子是我加上去的,弹出一个框显示结果,你可以检查
复制代码 |
|