How To Double Click to add/remove Tick in Microsoft Excel?
Tags: todoubleclicktoaddre, vbamacros
Published: 2021-10-19 06:23:20

---
title: How To Double Click to add/remove Tick in Microsoft Excel?
published: true
date: 2021-10-18 08:37:42 UTC
tags: ToDoubleClickToAddRe,VBAMacros
canonical_url: https://geekexcel.com/how-to-double-click-to-add-remove-tick-in-microsoft-excel/
---

In this blog post, you will learn how to  **double-click to Add/Remove the tick ** in Microsoft Excel. Let’s see them below!! Get the official version of  **MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Example

- Firstly, you need to **create a sample data** with some **food items**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-25.png)<figcaption>Sample data</figcaption>

- In the Excel Worksheet, you have to go to the  **Developer Tab.**
- Then, you need to ** ** select the  **Visual Basic**  option under the  **Code**  section.

![Select Visual Basic](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/09/Select-Visual-Basic-9-1024x180.png)<figcaption>Select Visual Basic</figcaption>

- Now, you have to  **copy and paste the code**  given below.

```
Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Checking whether target cell is in third column
If Target.Column = 3 Then
    
    'Prevent cell going into Edit Mode
    Cancel = True
    
    'Changing font type of the cell
    Target.Font.Name = "Marlett"
    
    'Checking if target cell value is blank then inserting tick
    If Target = "" Then
        Target = "a"
    Else
        Target = ""
    End If
End If
End Sub

```

- After that, you need to  **save the code**  by selecting it and then  **close the window**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Save-the-Code-53-1024x557.png)<figcaption>Save the Code</figcaption>

- Again, you have to go to the  **Excel Spreadsheet** , and click on the  **Developer Tab**.
- Now, you need to choose the  **Macros option**  in the Code section.

![Choose Macro option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/09/Choose-Macro-option-11-1024x184.png)<figcaption>Choose Macro option</figcaption>

- After that, on **double-clicking a cell** , a **tick mark will be added** to it.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-26.png)<figcaption>Output</figcaption>

- Finally, in the **same way** , it can be **removed by double-clicking** on it again.

## Sum-Up

In the above blog post, we have illustrated ** ** how to  **double-click to Add/Remove the tick**  in Microsoft Excel. Hope you like this article. Please feel free to state your  **query**  or  **feedback**  for the above article. Thank you so much for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[How to Show the Formula in a Cell in Excel Office 365!!](https://geekexcel.com/how-to-show-formula-in-a-cell-in-excel/)**
- **[Excel Formulas to Find the First Row Number ~ Useful Tutorial!](https://geekexcel.com/excel-formulas-to-find-first-row-number/)**
- **[Excel Formulas to Insert Double Quotes Inside the Output Cell!!](https://geekexcel.com/excel-formulas-to-insert-double-quotes-inside-the-cell/)**
- **[How to Edit a Formula in Excel ~ A Simple Tutorial!!](https://geekexcel.com/edit-a-formula-in-excel/)**