Simon,
Thanks, but I don't move the sheets, and the same sheet is always
active when this form loads and unloads. The value went to the right
sheet, and right cell, but no event was fired...

Simon Lloyd wrote in message ...
Without seeing the rest of your code it sounds like you moved the order
of sheets after you implemented your code, does the event happen on any
of the sheets?

Try your code in a new workbook with only one sheet if it works then it
will be the order of your sheets, i had this problem once when i added a
new sheet and then put it in alphabetical order all the other sheets
stopped working!

Simon