I would appreciate guidance with the following:
I have a block of code that runs on activation of a particular worksheet. I also want to run the same block of code whenever the value in Range("J2") on that worksheet is changed. Range("J2") is the only cell that this is to apply to.
Code
Private Sub Worksheet_Activate()
ColourIndex = 35
Range("B15").Activate
ActiveCell.Interior.Color = xlNone
If ActiveCell.Value = "" Then
ActiveCell.Interior.Color = xlNone
Else
ActiveCell.Interior.ColorIndex = ColourIndex
End If
End Sub
Display More
How do I modify my code so that the code runs on either of these two events?