help with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2831048%22%20slang%3D%22en-US%22%3Ehelp%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2831048%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20im%20not%20sure%20how%20to%20explain%20this....%20i%20want%20to%20double%20click%20on%20a%20cell%20and%20it%20will%20show%20a%20tick%20.%3C%2FP%3E%3CP%3Eim%20trying%20to%20add%20a%20tick%20off%20done%20list%20in%20excel.%3C%2FP%3E%3CP%3Ei%20hope%20you%20can%20understand%20my%20explanation.%3C%2FP%3E%3CP%3Ethank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2831048%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2831099%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2831099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1181075%22%20target%3D%22_blank%22%3E%40Lizzy_G%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CH1%20id%3D%22toc-hId-1471193355%22%20id%3D%22toc-hId-1471193227%22%20id%3D%22toc-hId-1471193227%22%20id%3D%22toc-hId-1471193227%22%20id%3D%22toc-hId-1471193227%22%20id%3D%22toc-hId-1471193227%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CU%3E%3CFONT%20color%3D%22%230000FF%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FFONT%3E%20%3C%2FU%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FH1%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%26nbsp%3B%20Ask%20away.%3C%2FP%3E%3CP%3EPlease%20include%20your%20%3CSTRONG%3EExcel%20version%3C%2FSTRONG%3E%2C%20%3CSTRONG%3Esample%20file%3C%2FSTRONG%3E%2C%20and%20a%20bit%20of%20%3CSTRONG%3Econtext%3C%2FSTRONG%3E%20to%20help%20others%20answer%20your%20question%3A%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3EMore%20infos%20in%20the%20upper%20Link.%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2831183%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2831183%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1181075%22%20target%3D%22_blank%22%3E%40Lizzy_G%3C%2FA%3E%26nbsp%3BPerhaps%20this%20code%20in%20the%20worksheet%20is%20what%20you%20mean%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-visual-basic%22%3E%3CCODE%3EPrivate%20Sub%20Worksheet_BeforeDoubleClick(ByVal%20Target%20As%20Range%2C%20cancel%20As%20Boolean)%0A%20%20%20%20ActiveCell.Value%20%3D%20Chr(195)%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EDouble%20click%20on%20a%20cell%20in%20the%20sheet%20where%20this%20code%20resides%20and%20it%20will%20come%20out%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-10-10%20at%2014.03.29.png%22%20style%3D%22width%3A%20132px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316382i7EADDBB5FF2086DC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-10-10%20at%2014.03.29.png%22%20alt%3D%22Screenshot%202021-10-10%20at%2014.03.29.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2831376%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2831376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bhi%26nbsp%3B%20thank%20you%20for%20replying.%26nbsp%3B%20i%20copied%20this%20and%3C%2FP%3E%3CP%3Epasted%20in%20a%20cell%20but%20it%20did%20not%20work.%20i%20have%20absolutely%20no%20clue%20what%20i%20am%20doing.%3C%2FP%3E%3CP%3Ei%20am%20making%20a%20list%20and%20when%20it%20has%20been%20completed%2C%20i%20want%20to%20double%20click%20in%20a%20cell%20and%20a%20tick%20will%20appear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@Lizzy_G 

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

 

NikolinoDE

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.

 

@Lizzy_G 

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.