Quote:
Originally Posted by NoSparks
The file I tested with.
|
I myself never use any events in Excel VBA except Open event. I assumed, that Change event behaves like the built-in one which contros autocalculation - after you leave the cell. When not, then it is similar to contlrol's Change event in Access - it is fired after every keystroke or mouse operation. I.e. when I type 10-character word into some cell, the Change event is fired 10 times! OK. An additional cause never use it