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