In Edit Mode (when the user IS entering data in a cell), no code can run. So
the user cannot click on a button.
You need to change your approach.

NickHK

wrote in message
ups.com...
Scenario : the user IS entering data in a cell on the active worksheet
and before hitting the enter ley or otherwise storing the data he typed
otherwise (by moving to another cell), he clicks on a command button on
the worksheet.
How can I make sure the data he (obviously) wanted to be entered ARE
actually stored in the cell and can be used in the macro assigned to
the button