請問:
工作表Worksheet_Change寫有巨集,其巨集內容主要是檢查值的改變
ex:當Target(被改變的欄位)=第6欄時,則會改變其他的欄位值
If Target.column= 6 Then
On Error Resume Next
On Error Resume Next
If value_1 = "ABC" Or value_1 = "" Then
Target.Offset(0, 1).Interior.ColorIndex = xlNone
Target.Offset(0, 1).Locked = False
Else
Target.Offset(0, 1) = ""
With Target.Offset(0, 1).Interior
.ColorIndex = 34
.Pattern = xlSolid
End With
End If
Target.Offset(0, 1).Locked = True
On Error GoTo 0
End If