Counting a cell as it transitions from a "1" to a

[stehaas]

I am looking to tally a count (in Excel) as a cell transitions from a "0" to a "1"
As cell "A-1" transitions from a "0" to a "1" while recieving the signal from a external DDE device. I would like cell "B-1" to count up every time it sees a "1" while getting its transition signal.
Example
"0" to "1" = 1
"0" to "1" = 2
"0" to "1" = 3
"0" to "1" = 4
"0" to "1" = 5

 

[stanleydgromjr]

stehaas,

Try this:

Press and hold down the 'ALT' key, and press the 'F11' key.

Copy the below code, and paste it into VBAProject, Microsoft Excel Objects, Sheet1(Sheet1): or the sheetname where you want the counter to update.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
    Application.ScreenUpdating = False
    If Target.Value = 1 Then
        Cells(1, 2) = Cells(1, 2) + 1
    End If
    Application.ScreenUpdating = True
End Sub

Each time cell A1 changes to a 1, the value in cell B1 will be updated by 1.

Have a great day,
Stan

 

[zzjasonzz]

Stan, although i have no idea how to do it that will not work 100% as if the cell was anything other than a 1 before it will count.

Example
"0" to "1" = 1
"1" to "2" = 1
"2" to "1" = 2

 

[stehaas]

incremental count

Stan,
Thank you for your reply...I will give this a try,
stehaas