hi
i have some vba code that works perfectly but only on cell c2 but would like it to work on every cell in column c
thanks in advance here my code
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If (Target.Address = "$C$2") Then If (Target.Value = "133") Then Dim varAnswer As String varAnswer = MsgBox("test") If varAnswer = vbNo Then Exit Sub End If If varAnswer = vbYes Then End If End If End If End Sub
Bookmarks