Excel 2007 : Can I set up a cell to subtract other cells if the value in that cell is over 0

[shaunn1812]

I have a situation where I need to be able to enter a number in a cell and have it subtract other cells automatically, but only if that number is greater than zero. I assume I'll need to set up some vb script to make this work the way I want, because any time I enter a number into a cell, the formula in that cell is deleted.

Any idea what I can do? Any help is appreciated.

Shaun

[Bob Phillips]

Please Login or Register  to view this content.

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.

[shaunn1812]

Thanks for that Bob. Just one question though (still getting the hang of vb). What exactly does the WS_RANGE refer to?

Shaun

edit: for example - I need to be able to enter a value in BB5 and have it automatically subtract AY5 and AV5
edit2: I also need to be able to apply this same code to multiple other cells in the same column
edit3: I think I got it. Thanks again!

[Bob Phillips]

[quote=shaunn1812;2578948]Thanks for that Bob. Just one question though (still getting the hang of vb). What exactly does the WS_RANGE refer to?/quote]

WS_RANGE is just a string constant I use to define the range of cells to be checked. Just change it to whatever cells apply for you.