第2个回答 2019-12-13
下面的代码测试通过,满足你的要求: Option Explicit Dim lastClick As String Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim x If Target.Address(False,False)="A7"Then Sheets("sheet2").Range("y1").ClearContents Else x=" Select Case lastClick Case"A5":x="x1 ...