|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim I As Long
With ListView1
If Target.Column > 0 And Target.Column < 6 Then
.Visible = True
.Left = Columns(6).Left
.Top = Target.Top + 10
.ColumnHeaders.Clear
.ListItems.Clear
.ColumnHeaders.Add , , "数字", 50
.ColumnHeaders.Add , , "百位次数", 80, lvwColumnCenter
.ColumnHeaders.Add , , "十位次数", 80, lvwColumnCenter
.ColumnHeaders.Add , , "个位次数", 80, lvwColumnCenter
.View = lvwReport
.Gridlines = True
.FullRowSelect = True
For I = 0 To 9
Set ITM = .ListItems.Add()
ITM.Text = I
ITM.SubItems(1) = Application.WorksheetFunction.CountIf(Range("C2:C" & Target.Row), I)
ITM.SubItems(2) = Application.WorksheetFunction.CountIf(Range("D2:D" & Target.Row), I)
ITM.SubItems(3) = Application.WorksheetFunction.CountIf(Range("E2:E" & Target.Row), I)
Next
Set ITM = Nothing
Else
.ListItems.Clear
.Visible = False
End If
End With
End Sub |
|