Change Event: a cell's value changes

[akardar1]

Hello there,

Having been trying to to get this code to work, the C3 cell is a DDE link with live feed.
What am Iam doing wrong ?
I read the similar posts, and unable to make this work.
Any help will be appreciated.


'Change event
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$3" Then
Run "tickcount"
End If

End Sub

'Tick count generation

Sub tickcount()
Range("d3").Value = Range("d3").Value + 1
End Sub

 

[JamesW]

Hi,

Instead of Run "tickcount", try just tickcount:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$C$3" Then tickcount
End Sub

 

[akardar1]

Thanks for your reply.
That doesnt seem to do the trick.

- If I run F5 on tickcount, i can see D3 incrementing by 1.
- Running F5 on the change event doesnt run it.
- Cell C3 changes every few seconds as its a live feed, so i expect D3 to automatically increase by one.

Any other ideas?
Thanks alot for your help

 

[JamesW]

Hi,

Things like live feeds will not trigger the change event, you may need a timer of somesort.

This may be of use: http://www.eggheadcafe.com/communit...t-change-event-with-bloomberg-live-addin.aspx

 

[akardar1]

Will look through this, thanks alot