Store data JUST entered in Activecell after clicking command button on worksheet
 

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

Store data JUST entered in Activecell after clicking command button on worksheet
 

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