I really like the answer to the first part of my title found in this thread Turning an excel cell into a check box
The code they gave to do that task is as follows:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
With Target
.Value = "Ö"
.Font.Name = "Symbol"
.Font.FontStyle = "Regular"
.Font.Size = 12
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
End With
End Sub
But can anyone tell me, how would I modify the above code to target only specific cells that are double clicked and not the entire sheet? For example just a range say A:1 through C:20 or multiple ranges on the sheet A:1 through C:20 and A:26 through C:46 or similar.
Also
How about the ability to remove the check mark if the cell is double clicked again?
Bookmarks