How to accumulate total in one cell from another if input changes

Hi,

I am trying to create a roulette excel game.

I have a cell with how much I want to bet and if I win then money is added to a cell, if I lose money is taken away.

So basically I have cell B8 which is where I enter how much money total I want use during the game, but not bet total, there will be other cells where I enter how much of that total I want to bet.

I then have a cell C8 which shows how much I won and adds that to cell D8. This cell D8 is what I want to accumulate. Im guessing I need a macro of some sorts.

I have use the below macro:

Please Login or Register  to view this content.

This works if I manually put a value in C8 but if I put a formula it does not work:

Please Login or Register  to view this content.

when E11=C3 it shows in cell C8 but does not accumulate.

Any advice?

Thanks

I have a suggestion for you..
I think you should trigger your code to the cell which you change last.. ( I mean in which you enter the amount,
expect result. )

Please Login or Register  to view this content.

Regards,

Hi, gigaplatinum,

please have a look at Forum Rule#3 to understand why you are asked to apply code-tags to your procedure.

Besides you are using the wrong event or the wrong area to view at in order to get the result.

Ciao,
Holger

A worksheet change event only fires (is triggered, or executed) when a manual change is made to a cell, or a cell is changed using code. It does NOT fire when a formula result changes.

So, instead of monitoring the cell with the formula, you need to monitor the cells it depends upon (it's precedents).


Regards, TMS