|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 YZC51 于 2019-8-28 11:05 编辑
请参考
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Union([s3:w3], [z3], [ab3], [C3:F16], [AO3:AQ3])) Is Nothing Then Exit Sub
If Target.CountLarge > 1 Then Exit Sub
Application.EnableEvents = False
If Target.Column = 41 Or Target.Column = 43 Then
[AO3:AQ3] = ""
Target.Value = "√"
Range("AR4:AR8").Value = Target.Offset(1).Resize(5, 1).Value
ElseIf Target.Column > 25 And Target.Column < 41 Then
[z3:ab3] = ""
Target.Value = "√"
ElseIf Target.Column > 17 Then
Range("s3:w3").ClearContents
Target.Value = "√"
End If
With Target
If .Row > 1 And .Column > 2 And .Column < 7 And Cells(.Row, 2) <> "" Then
If .Value = "√" Then .Value = "" Else .Value = "√"
End If
End With
Application.EnableEvents = True
End Sub
|
评分
-
1
查看全部评分
-
|