# How to Count Total Clicks in a Specified Cell in Excel?

When working with spreadsheets, keeping track of how many times a cell has been touched can be quite helpful, especially in situations where data entry or user interactions need to be watched. Excel offers a quick and efficient way to tally all clicks in a given cell, whether you want to monitor user behaviour or assess the popularity of a specific feature.

You will be able to track and examine user interactions in your Excel spreadsheets if you have a firm grasp of how to count the total number of clicks in a particular cell. So, let's get started and learn about the several ways to complete this assignment!

## Count Total Clicks in a Specified Cell

Here we will first insert a VBA code for the sheet to complete the task. So let us see a simple process to learn how you can count total clicks in a specified cell in Excel.

### Step 1

Consider any Excel sheet.

First, right-click on the sheet name and select View Code to open the VBA application, then copy the below code into the text box.

Right click > View code > Copy.

### Code

Public xRgS, xRgD As Range
Public xNum As Long
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If Target.Cells.Count > 1 Then Exit Sub
Set xRgS = Range("A2")
If xRgS Is Nothing Then Exit Sub
Set xRgD = Range("B2")
If xRgD Is Nothing Then Exit Sub
If Intersect(xRgS, Target) Is Nothing Then Exit Sub
xNum = xNum + 1
xRgD.Value = xNum
End Sub


In the code, A2 is the cell, and B2 is the value recorded in the cell.

### Step 2

Then click Alt + Q to close, then VBA. From now on, when you click on cell E2, the value in cell H2 will be increased.

This is how you can count the total clicks in a specified cell in Excel.

## Conclusion

In this tutorial, we have used a simple example to demonstrate how you can count total clicks in a specified cell in Excel to highlight a particular set of data.

Updated on: 22-Aug-2023

197 Views