Excel 三级联动选择一级清空二三级,选择二级情况三级
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rng As Range
'MsgBox (Target.Row)
If Target.Row < 2 Then Exit Sub
For Each Rng In Target
'MsgBox (Rng.Column)
If Rng.Column = 5 Then
Target.Next.ClearContents
Target.Next.Next.ClearContents
End If
If Rng.Column = 6 Then
Target.Next.ClearContents
End If
Next
End Sub