I'm trying to update an outside cell every time a certain condition is met;
is there anything like a C++ += or ++ command - i.e. everytime 1000 value
500, F8=F8+1?

MikeDH wrote...
I'm trying to update an outside cell every time a certain condition is met;
is there anything like a C++ += or ++ command - i.e. everytime 1000 value
500, F8=F8+1?

No. One cell can't change the value in another cell EXCEPT when the 2nd
cell contains a formula referring to the 1st cell. You need to use a
Calculate event handler to check that Value has changed, and if so
increment cell F8 using a VBA statement like

Range("F8").Value = Range("F8").Value + 1