How to double click a cell and add 1 to that cell value in Excel?

This article will show you method of add 1 to a cell value automatically with double clicking it in Excel.

Double click a cell and add 1 with VBA code

Double click a cell and add 1 with VBA code

The following VBA code can help you add 1 to a cell value after double clicking. Please do as follows.

1. Right click the sheet tab which the cell values you need to add 1 with double clicking. Then click View Code from the right-clicking menu.

2. In the popping up Microsoft Visual Basic for Applications window, copy and paste the below VBA code into the Code window.

VBA code: Add 1 to a cell value with double clicking

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    On Error Resume Next
    If Not Intersect(Target, Range("A1")) Is Nothing Then
      Range("A1").Value = Range("A1").Value + 1
      Cancel = True
    End If
End Sub

Note: In the code, A1 is the cell you will add number 1 to with double clicking.

3. Press the Alt + Q keys simultaneously to close the Microsoft Visual Basic for Applications window.

Now, double click on cell A1 will add 1 to the existing value as below screenshot shown.

Related articles:

• How to auto add/enter current date/time in a cell with double clicking in Excel?
• How to add check mark in a cell with double clicking in Excel?