fastballfreddy
Board Regular
- Joined
- Jan 13, 2015
- Messages
- 64
- Office Version
- 2016
- Platform
- Windows
I've searched and I was able to find a way to run a macro based on a cell value but it only works if I type in the cell and doesn't work if I put a formula in the cell and it changes. Is there a way to run a macro based off a cell that has a formula?
sample of my current formula that works if I type in cell A1.
sample of my current formula that works if I type in cell A1.
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
'Cyclones Win 2nd Game
If Range("A3").Value = "" And Range("A4").Value = "" And Range("A1").Value = "cyclones" Then
Range("A3").Select
ActiveCell = "x"
'Cyclones Win 2nd Game
ElseIf Range("B3").Value = "" And Range("B4").Value = "" And Range("A1").Value = "cyclones" Then
Range("B3").Select
ActiveCell = "x"