jt formulated on Monday :
On Apr 18, 12:30*am, GS wrote:
GS presented the following explanation :

The code in Worksheet_Change fires when you exit the cell. Using the tab
key exits the cell if your entry was done by just typing without entering
'Edit Mode' by menu, F2, or double-clicking the cell.

Correction: the Tab key exits whether in 'Edit Mode' or not.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

but it doesn't fire when I hit the tab key?

It does when I hit the Tab key (if the contents were edited).

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc