View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Google@runit.nl is offline
external usenet poster
 
Posts: 2
Default 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