Add Check Marks to Cells by Double-Clicking or Typing

Add to Favorites
Author: | Edits: don

Input a check mark into a cell in Excel by double-clicking the cell or by typing a letter into it.

This tutorial shows you two ways to input the check mark because you might want to use the mouse to input or remove the check mark or quickly key through a list and type a sinlge letter to input the check mark.

There are many ways to perform this trick in Excel, but, here, I will show you one of the easier ways to do it, which combines a custom font and a macro.

Custom Font

Font to use: Marlett

Letter to input to make the check-mark: a

Macro for the Double-Click

Right-click the sheet where you want to have this trick work and click View Code and paste the code from here.

B3:B6 change this to the range of cells that should be able to get a check mark when they are double-clicked.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
' Add/Remove a Check Mark from a Cell
'
' Made by: https://www.TeachExcel.com
'
' Excel Courses: https://www.teachexcel.com/premium-courses/?src=tut_id_2444
 
    If Not Intersect(Target, Range("B3:B6")) Is Nothing Then
    
        Target.Font.Name = "Marlett"
    
        If Target.Value = "a" Then
            
            Target.Value = ""
            
        Else
        
            Target.Value = "a"
        
        End If
        
        Cancel = True
    
    End If
    
End Sub

Additional Resources

Microsoft Doc to Insert a check mark symbol

Worksheet.BeforeDoubleClick event (Excel)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Link to Cells on Other Worksheets in Excel
Tutorial: It is very easy to link one cell to another cell in Microsoft Excel. The steps needed are ...
3 Methods to Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all space...
How to Input, Edit, and manage Formulas and Functions in Excel
Tutorial: In this tutorial I am going to introduce how to input, edit and manage excel formulas. To ...
Enter Text/Characters with a Double-Click of the Mouse
Macro: This macro allows you to enter any text or number, that you specify, in a cell on whic...
How to Add Formatting to Cells and Data in Excel Styles, Fonts, Colors, & More
Tutorial: In this tutorial I will cover how to use the various formatting tools in Excel. The Format...
Add Notes and Comments to Cells in Excel
Tutorial: Did you know that you can add notes and comments to any cell in Excel?  You can write re...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Link to Cells on Other Worksheets in Excel
Tutorial: It is very easy to link one cell to another cell in Microsoft Excel. The steps needed are ...
3 Methods to Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all space...
How to Input, Edit, and manage Formulas and Functions in Excel
Tutorial: In this tutorial I am going to introduce how to input, edit and manage excel formulas. To ...
Excel Forum