I have found that Worksheet_Change is fired just by dbl-clicking on acell and then pressing Enter.Is this a bug? Or am I working in a wrong mode, or what?I have programmed with Excel a few times, but I have never yet usedthis event.
Not a bug. Not the wrong mode. That's just how it works.It doesn't try to keep the previous contents and do a comparison. Ifyou take a cell into edit mode and then leave the cell without Escape,the cell is considered changed.There are indeed times when doing that will change the value of thecell. E.g. if you have somehow got a text version of a date into acell, then doing this will get Excel to re-evaluate the cell and treatit as a date.