Excel中表格的级联删除

归来少年Plus

已于 2023-03-09 11:26:52 修改

阅读量309

点赞数

文章标签： excel

于 2023-03-09 10:52:58 首次发布

本文链接：https://blog.csdn.net/weixin_41709748/article/details/129418660

版权

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then Range("$C2,$D2").ClearContents
If Target.Address = "$C$2" Then Range("$D2").ClearContents
If Target.Address = "$B$4" Then Range("$C4,$D4").ClearContents
If Target.Address = "$C$4" Then Range("$D4").ClearContents
End Sub