Cymatic Trader Community

[stiggits]

Hi,

I am trying to update cells with VBA using the "Worksheet_Change" function,
but this seems to only work with manual changes.
Can someone tell me what I need to use for automatically updated cells.
Thanks.

[Gavin]

Hi stiggits,

Have a look at the Worksheet_Calculate function for automatically updated cells, which pplies when the resulting value of a formula changes.

Kind regards,

Gavin

[stiggits]

Thank Gavin,
That seems to be working better now,
although it causes some issues with cell formulas which reference
cells in the code, but I think I can work around that.
Thanks,
Steve.

[Gavin]

Hi stiggits,

Glad to hear it


You can use the INTERSECT() function at the start of your WorkSheet_Calculate to decide whether to do your code based on whether certain cells caused Worksheet_Calculate to fire.

For example, something along the lines of:

Code: Select all

If Not Intersect(Target, Range("B4")) Is Nothing Then
---Do your code here----
EndIf

Search this forum (search box is in top right corner usually) for the word INTERSECT and you'll find other examples of it being used.

Kind regards,

Gavin