Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 203
- Office Version
- 2021
The following code works fine as it is. A change in A1 text will log the balance.
However I would like the code to run on a change of a True False formula in cell X1. The formula is the following; =(COUNTIF($H$5:$H$100,">0")=1)
I'm struggling with this any ideas please
TIA
However I would like the code to run on a change of a True False formula in cell X1. The formula is the following; =(COUNTIF($H$5:$H$100,">0")=1)
I'm struggling with this any ideas please
TIA
VBA Code:
Option Explicit
Dim currentMarket As String
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
If [A1] <> currentMarket Then
currentMarket = [A1]
logBalance
End If
End If
End Sub