How to Pop Up the Cell Value While Clicking in Excel?

Excel is a robust programme that is frequently used for data organisation and analysis. While it excels in manipulating and storing data, it also provides a number of capabilities to improve user experience and data visibility. Making pop-up cell values is one such function that enables users to access extensive information without clogging the spreadsheet. You may quickly get extra data or context related to a certain cell by clicking on it thanks to the click capability.

In this article, we'll show you how to use Excel's click function to implement pop-up cell values. You will discover how to add custom information when clicking on particular cells, make user-friendly pop-up windows, and assign macros to cells. Whether you're a novice or seasoned Excel user, this course will provide you the information and abilities to improve the functionality of your spreadsheet and speed up data analysis.

Pop Up the Cell Value While Clicking

Here we will insert the VBA code into the sheet to complete the task. So let us see a simple process to see how you can pop up the cell value while clicking in Excel.

Step 1

Consider any Excel sheet.

First, right-click on the sheet name and select View Code to open the VBA application.

Right click > View code.

Step 2

Then copy below code into the text box.


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   Application.ScreenUpdating = False
   If Target.Count > 1 Then Exit Sub
   If Target.Value = "" Then Exit Sub
   Target.AddComment Target.Value
   Application.ScreenUpdating = True
End Sub

Step 3

Then use Alt+Q to save and close the VBA. Then you can see that the cell value will pop up when the cell is clicked.

This is how you can pop up cell values when clicking in Excel.


In this tutorial, we have used a simple example to demonstrate how you can pop up the cell value while clicking in Excel to highlight a particular set of data.

Updated on: 07-Sep-2023


Kickstart Your Career

Get certified by completing the course

Get Started