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.
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
How do I modify my code so that the code runs on either of these two events?