Hey there
I need code so that when a cell is clicked, a tick mark goes in the cell that was clicked. This could include a dash, checkmark, dot and etc. I also want it so that if a cell that is already ticked is clicked, its tick gets removed. I want this to apply to all cells except the first row (1) and first column (A). I am not good with programming so if you provide the code, can you tell me where to place it?
Thanks in advance
benham,
Give this a try:
Please Login or Register to view this content.
To place the code, right click on the sheet you want to monitor for cell clicks, and select "View Code", then copy/paste the code into there.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Copy this code and paste it into the worksheet module:
Is that something you can work with?Please Login or Register to view this content.
Last edited by Ron Coderre; 08-08-2013 at 11:54 AM.
Hey tiger
I tried your code and it worked perfectly. Just one thing. When i click on a cell and "#" appears, i need to click on another cell in order to click on the previous cell and remove the "#". Is there a way to make the double click work.
Thanks
Hey tiger
I tried your code and it worked perfectly. Just one thing. When i click on a cell and "#" appears, i need to click on another cell in order to click on the previous cell and remove the "#". Is there a way to make the double click work.
Thanks
behnam,
You could call the SelectionChange event from the BeforeDoubleClick event:
So after you click on a cell, you can double-click it to togglePlease Login or Register to view this content.
If you check the code I posted, it actually selects the cell to the right of the tick-mark cell after setting its value. That way each click on the cell toggles its value.
Thanks guys this worked perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks