Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then
If Len(Target.Value) = 0 Then
Application.EnableEvents = False
Target.Value = "Spare"
Application.EnableEvents = True
End If
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then
If Len(Target.Value) = 0 Then
Application.EnableEvents = False
Target.Value = "Spare"
Application.EnableEvents = True
End If
End If
If Target.Address(0, 0) = "A2" Then
If Len(Target.Value) = 0 Then
Application.EnableEvents = False
Target.Value = "Spare"
Application.EnableEvents = True
End If
End If
End Sub
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1,A3,B5:B10")) Is Nothing Then
If Len(Target.Value) = 0 Then
Application.EnableEvents = False
Target.Value = "Spare"
Application.EnableEvents = True
End If
End If
End Sub