How to save and close active workbook without prompt by a Command Button in Excel?.Click the Command Button to change the specified cell value to your requirements. Then press the Alt + Q keys simultaneously to close the Microsoft Visual Basic for Applications window.ĥ. Note: In the code, CommandButton1 is the name of command button you have inserted just now.Ĥ.

VBA 3: Making value in cell A1 equals to E1 Private Sub CommandButton1_Click() VBA 2: Changing value in cell A1 which equals to E1 plus 1 Private Sub CommandButton1_Click()

VBA 1: Changing value in cell A1 with adding 1 Private Sub CommandButton1_Click() Please replace the original code with the following VBA scripts as you need: Then the Microsoft Visual Basic for Applications window pops up. Right click the Command Button, then click View Code from the context menu. Insert a Command Button by clicking Developer > Insert > Command Button (ActiveX Control). Please do as follows to solve these problems.ġ. Supposing you want to change value in cell A1 with adding 1, change value in cell A1 which equals to E1 plus 1, or make value in cell A1 equals to E1 after clicking the Command Button. Use a Command Button to change a specified cell value with VBA code If you want to change a specified cell value with clicking on a Command Button in Excel, you can try the methods in this article. How to use a Command Button to change a specified cell value in Excel?

Excel command buttons stopped working