Perhaps what you actually want is to avoid the selected
cell moving after pressing Enter (or TAB). If so,
deselect the 'Move selection after Enter' checkbox on the
Edit Tab of the Tools,Options menu.

HTH

Graham


-----Original Message-----
Hi Heiko,
Thanks for your efforts to help me. I am very new to
Excel
and Visual Basic. Could you elaborate on your advice? I
don't understand the specifics.
Again Thanks,
Sisilla
-----Original Message-----
Hello
define a Shortcut for this operation.
:-)
"Sisilla" wrote:

When a user enters data into a cell, he has to tab out
of
it before he can push the "calculate" button. Is there
any
way to change this so that the calculation can be
performed while the cell is still selected? I
appreciate
any help.

.

.