|
有个小插件需要老师帮忙写注解~~
请老师帮帮忙些个注解~看不明白呢~~- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Column = 1 And Target.Count = 1 And Target.Row > 2 Then Range("E100").End(3)(2) = Target
- If Target.Column = 2 And Target.Count = 1 And Target.Row > 2 Then Range("F100").End(3)(2) = Target
- If Target.Column = 3 And Target.Count = 1 And Target.Row > 2 Then Range("G100").End(3)(2) = Target
- If Target.Column > 4 And Target.Column < 8 And Target.Count = 1 Then
- Target = ""
- C = Target.Column
- For I = Target.Row To Cells(100, C).End(3).Row
- Cells(I, C) = Cells(I + 1, C)
- Next
- End If
- End Sub
复制代码 谢谢了哦
不知道这样写能不能明白: - Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- '当当所选前单元格所在列为A列,且选中的单元格个数为1个,同时该单元格的行号大于2时,将该单元格的值追加至E列
- '即实现单机A列除A1,A2单元格以往的任意单元格,将该单元格的值追加至E列末尾
- If Target.Column = 1 And Target.Count = 1 And Target.Row > 2 Then Range("E100").End(3)(2) = Target
- '即实现单机B列除B1,B2单元格以往的任意单元格,将该单元格的值追加至F列末尾
- If Target.Column = 2 And Target.Count = 1 And Target.Row > 2 Then Range("F100").End(3)(2) = Target
- '即实现单机C列除C1,C2单元格以往的任意单元格,将该单元格的值追加至G列末尾
- If Target.Column = 3 And Target.Count = 1 And Target.Row > 2 Then Range("G100").End(3)(2) = Target
- '当单击选中E-G列中的任意一个单元格时执行清空当前所选单元格,且将下面的数据上移
- If Target.Column > 4 And Target.Column < 8 And Target.Count = 1 Then
- '清空当前单元格的值,使其为空
- Target = ""
- '取得当前单元格所在的列号
- C = Target.Column
- '通过for循环将当前单元格下面的值往上移动
- For I = Target.Row To Cells(100, C).End(3).Row
- Cells(I, C) = Cells(I + 1, C)
- Next
- End If
- End Sub
复制代码
|
|