<div>
Clicking on any command button (that you have added to a worksheet) automatically closes the cell entry.<br />
<br />
Kevin
</div>


<div>
What are you trying to accomplish? Do you want to use a mouse action instead of a keyboard action?<br />
<br />
Kevin
</div>


<div>
There is also a green check mark in the formula bar you can click to close the cell.<br />
<br />
Kevin
</div>


<div>
If I select a cell and change the nymbers in a cell...no buttons will work until I hit enter or shift. &nbsp;I would like to be able to click a form button and have the cell value be automatically registered. &nbsp;Are you saying this would work with a command button?
</div>


<div>
Perhaps you can enter the new value in a user form and, when you click OK on the form, the value is pushed to the desired cell and your VBA code can continue.<br />
<br />
Kevin
</div>


<div>
That is a good idea...my app is just too big for that, however. &nbsp;My users will just have to get used to this.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
Can anyone tell me if it is possible to enter a new value into a cell and have Excel accept that value after clicking a button rather than having to hit enter or shift first?
</div>
</div>


Hello,
Can anyone tell me if it is possible to enter a new value into a cell and have Excel accept that value after clicking a button rather than having to hit enter or shift first?

Clicking on any command button (that you have added to a worksheet) automatically closes the cell entry.

Kevin

What are you trying to accomplish? Do you want to use a mouse action instead of a keyboard action?

Kevin

There is also a green check mark in the formula bar you can click to close the cell.

Kevin

If I select a cell and change the nymbers in a cell...no buttons will work until I hit enter or shift.  I would like to be able to click a form button and have the cell value be automatically registered.  Are you saying this would work with a command button?

Perhaps you can enter the new value in a user form and, when you click OK on the form, the value is pushed to the desired cell and your VBA code can continue.

Kevin

That is a good idea...my app is just too big for that, however.  My users will just have to get used to this.

Want Excel to accept cell value by clicking button, not using ENTER key

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.