Forum Discussion

Copper Contributor

Oct 10, 2021

help with formula

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 ...

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Oct 10, 2021

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:

Lizzy_G

Copper Contributor

Oct 10, 2021

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.