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

  • Thread starter Thread starter Google
  • Start date Start date
G

Google

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button Question 8
Create a yes no message on a command button on click 0
Copy filtered data to sheet 2 1
How to use multiple command button to copy user form data to multiple worksheet 0
determine if activecell in specific worksheet and column 6
"Double Click" macro? 3
Excel 2013 Merge Data 2
Find value of active cell in other visible worksheets 8

Back
Top