|
发表于 2014-3-3 16:02
|
显示全部楼层
本楼为最佳答案
- Private Sub Spreadsheet1_SheetChange(ByVal Sh As OWC10.Worksheet, ByVal Target As OWC10.Range)
- On Error Resume Next
- Application.ScreenUpdating = False
- Dim rg As OWC10.Range
- Range(Target.Address).Value = Target.Value
- Application.ScreenUpdating = True
- End Sub
- Private Sub UserForm_Initialize()
- ListView1.BorderStyle = ccFixedSingle '设置边框样式。
- ListView1.View = lvwReport '设置 View 属性为报表型(表格)。
- ListView1.ListItems.Clear
- ListView1.ColumnHeaders.Clear
- With ListView1
- .ColumnHeaders.Add , , "序号", 30
- .ColumnHeaders.Add , , " 编号", 45
- .ColumnHeaders.Add , , " 名称及规格", 220
- .ColumnHeaders.Add , , "单位", 28
- .ColumnHeaders.Add , , " 数量", 60
- .ColumnHeaders.Add , , " 单价", 60
- .ColumnHeaders.Add , , " 合价", 60
- .ColumnHeaders.Add , , " 备注", 68
- End With
- With Spreadsheet1
- .EnableEvents = False
- .Range("a1:k1000").Font.Size = 10
- .Range("a1:a1000").RowHeight = 11
- .Range("a1:a1").ColumnWidth = 30 / 7
- .Range("b1:b1").ColumnWidth = 45 / 6.5
- .Range("c1:c1").ColumnWidth = 220 / 6.11
- .Range("d1:d1").ColumnWidth = 28 / 7
- .Range("e1:e1").ColumnWidth = 60 / 6.4
- .Range("f1:f1").ColumnWidth = 60 / 6.4
- .Range("g1:g1").ColumnWidth = 60 / 6.4
- .Range("h1:h1").ColumnWidth = 60 / 6.4
- With .Range("a1:a1000")
- .HorizontalAlignment = xlLeft
- .VerticalAlignment = xlCenter
- .NumberFormat = "@"
- End With
- With .Range("b1:b1000")
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- .NumberFormat = "@"
- End With
- With .Range("c1:c1000")
- .HorizontalAlignment = xlLeft
- .VerticalAlignment = xlCenter
- .NumberFormat = "@"
- End With
- With .Range("d1:d1000")
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- .NumberFormat = "@"
- End With
- With .Range("e1:e1000")
- .HorizontalAlignment = xlRight
- .VerticalAlignment = xlCenter
- .NumberFormat = "0.00"
- End With
- With .Range("f1:f1000")
- .HorizontalAlignment = xlRight
- .VerticalAlignment = xlCenter
- .NumberFormat = "0.00"
- End With
- With .Range("g1:g1000")
- .HorizontalAlignment = xlRight
- .VerticalAlignment = xlCenter
- .NumberFormat = "0.00"
- End With
- End With
- For i = 1 To Worksheets(1).Cells(65536, 1).End(xlUp).Row
- Spreadsheet1.Cells(i, 7) = 0
- For j = 1 To 6
- Spreadsheet1.Cells(i, j) = Worksheets(1).Cells(i, j)
- Spreadsheet1.Cells(i, 7) = Spreadsheet1.Cells(i, 7) + Spreadsheet1.Cells(i, 5) * Spreadsheet1.Cells(i, 6)
- Next j
- Spreadsheet1.Cells(i, 8) = Worksheets(1).Cells(i, 8)
- Next i
- Me.Spreadsheet1.EnableEvents = True
- End Sub
复制代码 |
|