|
本帖最后由 SlimEvans 于 2022-7-27 17:10 编辑
是不是这样的效果,看下
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(8, 1) = 1 Then
If Not Application.Intersect(Target, Range("A11:A20")) Is Nothing And Target.Count = 1 Then
Cells(11, 8) = Target.Row - 11
End If
ElseIf Cells(8, 1) = 2 Then
If Not Application.Intersect(Target, Range("A11:A20")) Is Nothing And Target.Count = 1 Then
Cells(12, 8) = Target.Row - 11
End If
End If
End Sub
|
评分
-
查看全部评分
|