Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF

Add to Favorites

This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods to insert a check-mark into Excel, including using Macros/VBA and a UDF, or User Defined Function.

Sections:

Basic Method to Insert a Check Mark into Excel

VBA Method to Insert a Check Mark into Excel

UDF that Inserts a Check Mark into Excel

Notes

Basic Method to Insert a Check Mark into Excel

This is the most basic way you can enter a check-mark, but it's kind of time consuming.

  1. Select the cell where you want the check-mark to go.
  2. Go to the Insert tab and click the Symbols button and then Symbol

  3. In the window that opens, go to the Symbols tab and select the Wingdings font from the Font: drop down at the top.
  4. Scroll down to the bottom and choose the check-mark symbol:
  5. Hit the Insert button once and then hit the Cancel button and you will now see the check-mark in Excel.

Repeatedly Enter the Check Mark with Ease

Now that you have a check-mark, you may want to enter it again and again. To do that, select the cell with the mark and hit Ctrl + C and then go to where you want it, select that cell, and hit Ctrl + V. Simple copy/paste.

VBA Method to Insert a Check Mark into Excel

To enter a check-mark using VBA, it's actually very simple.

  1. Go to the VBA Editor window, Alt + F11, then to Insert > Module.
  2. Paste this code into your macro:
    ActiveCell.Value = ChrW(&H2713)
  3. The final macro, in its simplest form can look like this:
  4. Go back to Excel (Alt + F11) and select a cell, hit Alt + F8, select the macro, hit Run and you have another check-mark in Excel.

UDF that Inserts a Check Mark into Excel

This allows you to use a simple function that you create to add a check mark to Excel.

  1. Go to the VBA Editor window (Alt + F11) and add a module (Insert >Module) and then add this code:
    Function CheckMarkAdd()

       CheckMarkAdd = ChrW(&H2713)

     End Function

  2. Go back to Excel, Alt + F11, and go to the desired cell and type your new function =CheckMarkAdd()

  3. Hit Enter and that's it!

Using this method, you only ever have to remember the UDF that you created and, in less than a second, you can type it in, hit Enter, and you have your check-mark.

This is my favorite method to use!

Notes

All of the above methods come in handy depending on the situation. My person favorite is the UDF method because I love UDFs and it's just so simple to use.

Download the sample workbook attached to this tutorial to get all of the code used here and try it yourself.


Downloadable Files: Excel File