Recording Cell Value

[Forever Forest]

Hi,

I've got a basic VBA that means when I enter a value into A1 (sheet 1), that value is remembered, with the time, and recorded in sheet 2. As I manually change the value in A1, the new data is captured and recorded.

But, when I try and automate this (connect A1 to Match Odds (Draw) ), the data does not update as it changes.

Anyone know why?

(calculate is set to automatic)

[Gavin]

Hi Forest Forever,

You would need to put your code into the Worksheet_Change or Worksheet_Calculate event of the sheet in which the data changes. Which event contains your VBA code?

Kind regards,

Gavin

[Forever Forest]

Thanks Gavin.

I've looked at the code and it says Worksheet_Change.

Not that means much to me (someone else wrote it)

[Gavin]

Move the code to the Worksheet_Calculate event. This event will be triggered when your formula re-calculates.

Whereas Worksheet_Change won't be triggered if your formula simply gets a new value because it references a cell in another worksheet that has changed.

Kind regards,

Gavin