help with formula

New Contributor

Hi.  im not sure how to explain this.... i want to double click on a cell and it will show a tick .

im trying to add a tick off done list in excel.

i hope you can understand my explanation.

thank you in advance.

5 Replies


Welcome to your Excel discussion space!

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

Please include your Excel version, sample file, and a bit of context to help others answer your question:

More infos in the upper Link.


Thank you for your understanding and patience



I know I don't know anything (Socrates)

@Lizzy_G Perhaps this code in the worksheet is what you mean:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, cancel As Boolean)
    ActiveCell.Value = Chr(195)
End Sub

Double click on a cell in the sheet where this code resides and it will come out like this:

Screenshot 2021-10-10 at 14.03.29.png

@Riny_van_Eekelen hi  thank you for replying.  i copied this and

pasted in a cell but it did not work. i have absolutely no clue what i am doing.

i am making a list and when it has been completed, i want to double click in a cell and a tick will appear.



The text posted by Riny is VBA code. It belongs in the worksheet module.

See the attached sample workbook. If you want to inspect the code, right-click the sheet tab and select 'View Code' from the context menu.

@Lizzy_G I was not clear. Sorry. The code need to be entered into a cell. It need to go into the "code for for the worksheet you are working in".


Right-click on the sheet tab and select "View code"

Screenshot 2021-10-10 at 16.44.40.png

This will open the Visual Basic editor.

Then, copy the code like in the picture below:

Screenshot 2021-10-10 at 16.45.06.png

Now save the workbook, macro-enables (I.e. xlsm)

I've attached such a workbook, so that you see how it should look like.

The above screenshots were made on a Mac, bit it's similar on a PC.