I'm totally new to VBA and this is my first attempt which is failing due to I think they all try to run and overlap causing the wrong boxes to reset. Please can someone advise me how to correct this I have searched so many threads trying to find and answer.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A226:A290")) Is Nothing Then
ActiveCell.Offset(0, 6).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("G226:G290")) Is Nothing Then
ActiveCell.Offset(0, 1).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("R226:R290")) Is Nothing Then
ActiveCell.Offset(0, 1).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("A302:A310")) Is Nothing Then
ActiveCell.Offset(0, 6).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("G302:G310")) Is Nothing Then
ActiveCell.Offset(0, 1).Range("A1").Value = "Please Select"
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A226:A290")) Is Nothing Then
ActiveCell.Offset(0, 6).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("G226:G290")) Is Nothing Then
ActiveCell.Offset(0, 1).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("R226:R290")) Is Nothing Then
ActiveCell.Offset(0, 1).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("A302:A310")) Is Nothing Then
ActiveCell.Offset(0, 6).Range("A1").Value = "Please Select"
End If
If Not Intersect(Target, Range("G302:G310")) Is Nothing Then
ActiveCell.Offset(0, 1).Range("A1").Value = "Please Select"
End If
End Sub