Hi there,
I want to enter a tick by double clicking in a cell.
And another double click should remove that tick.
I have a range say suppose from B1:D1
B1 may represent as "applicable" C1 may represent as "Not Applicable" D1 may represent as "Not sure"
Help will be highly appreciated.
Thanks
I am trying this code but I am getting debug (in red) when I try to clear the cell
Please Login or Register to view this content.
May be
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Sorry, I forgot to add the cell is merged...
It is better to attach a sample of your file
Try avoiding merging cells. It is the enemy of codes
Please see attached
Hi ! Try this ‼
According to your attachment, to paste to the worksheet module (replacing same event procedure yet existing) :
PHP Code:Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Target(1)
If .Row > 12 And .Column > 1 And .Column < 5 Then
.Value = Array("", ChrW(10003))(-(.Value = ""))
Cancel = True
End If
End With
End Sub
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
Last edited by Marc L; 07-16-2018 at 06:55 AM.
Or just a small tweak to the original:
Please Login or Register to view this content.
Thanks Legends!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks