Recording Cell Value

Questions about integrating Excel and Cymatic, programming, formulae, etc

Recording Cell Value

Postby Forever Forest » Sun Feb 17, 2019 3:54 pm

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)
Forever Forest
 
Posts: 9
Joined: Sun Apr 06, 2014 8:37 am

Re: Recording Cell Value

Postby Gavin » Mon Feb 18, 2019 11:42 pm

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
User avatar
Gavin
Site Admin
 
Posts: 3217
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Recording Cell Value

Postby Forever Forest » Tue Feb 19, 2019 2:59 pm

Thanks Gavin.

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

Not that means much to me (someone else wrote it)
Forever Forest
 
Posts: 9
Joined: Sun Apr 06, 2014 8:37 am

Re: Recording Cell Value

Postby Gavin » Tue Feb 19, 2019 8:04 pm

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
User avatar
Gavin
Site Admin
 
Posts: 3217
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom


Return to Excel - Help / Support

Who is online

Users browsing this forum: No registered users and 0 guests

cron