MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Worksheet_Change fired just by dbl-clicking on a cell and then press

  Asked By: Hasan    Date: Nov 22    Category: MS Office    Views: 812

I have found that Worksheet_Change is fired just by dbl-clicking on a
cell 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 used
this event.



1 Answer Found

Answer #1    Answered By: Botan Suzuki     Answered On: Nov 22

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. If
you 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 the
cell. E.g. if you have somehow got a text version of a date into a
cell, then doing this will get Excel to re-evaluate the cell and treat
it as a date.