check for changes 1

[cspm2003]

Hi,

I have a little VBA problem:

I have a SpreadSheet named "Test" with a Table named "Table1" for example. SpreadSheet is allways open. now, in field A0 is normally a "0". When the table gets updated, the "0" gets changed to a "1". What would I have to write in the macro to constantly check if the field is changed to a "1" ?

cheers

 

[xlbo]

have a look at excel EVENTS in the helpfiles - specifically, the worksheet CHANGE event

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[cspm2003]

thx, I figured it out with events.