(4)当用户选定的单元格的值和它左边单元格相等时,选定的单元格的值加1 大家不用考虑用错的问题 可以在代码首行加上 on error resume next
例1:Luckyguy:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If Target.Value = Target.Offset(0, -1).Value Then Target.Value = Target.Value + 1 End If End Sub
(5)当选定区域是A1并且只包含A1单元格时才给出提示 例1:逍遥自在 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count = 1 And Target.Row = 1 And Target.Column = 1 Then MsgBox "你选中了A1单元格" End If End Sub
|