Tested in Excel 2003 fr, Excel 2007 fr, Excel 2010 beta en.
When you enter any character in a cell, the Worksheet_SelectionChange
event macro is fired (the target cell is still the active cell, no move
after entry).
Anyone heard of it ?
TIA
Daniel

code NOT restricted?
As ALWAYS, post your code for comments.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Daniel.C" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Tested in Excel 2003 fr, Excel 2007 fr, Excel 2010 beta en.
> When you enter any character in a cell, the Worksheet_SelectionChange
> event macro is fired (the target cell is still the active cell, no move
> after entry).
> Anyone heard of it ?
> TIA
> Daniel
>
>

Just add the following macro to a sheet in a blank workbook :

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "Selection change " & Target.Address
End Sub

> code NOT restricted?
> As ALWAYS, post your code for comments.

That is normal. When you go into edit mode, then press Enter, the old active
cell is re-selected. If you programmatically change the value of a cell
(even re-apply the same value) only the 'Change' event will fire.

(There are one or two other programmatic actions which will trigger the
SelectionChange without doing anything at all to cells)

Regards,
Peter T

"Daniel.C" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Tested in Excel 2003 fr, Excel 2007 fr, Excel 2010 beta en.
> When you enter any character in a cell, the Worksheet_SelectionChange
> event macro is fired (the target cell is still the active cell, no move
> after entry).
> Anyone heard of it ?
> TIA
> Daniel
>
>

Thanks. Good to know anyway, even if I can't think that it's normal.
Daniel

> That is normal. When you go into edit mode, then press Enter, the old active
> cell is re-selected. If you programmatically change the value of a cell (even
> re-apply the same value) only the 'Change' event will fire.
>
> (There are one or two other programmatic actions which will trigger the
> SelectionChange without doing anything at all to cells)
>
> Regards,
> Peter T
>
> "Daniel.C" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Tested in Excel 2003 fr, Excel 2007 fr, Excel 2010 beta en.
>> When you enter any character in a cell, the Worksheet_SelectionChange
>> event macro is fired (the target cell is still the active cell, no move
>> after entry).
>> Anyone heard of it ?
>> TIA
>> Daniel
>>
>>