How to make a cell a generic checkbox

[Cheeba]

This is (almost!) exactly what i've been looking for...
http://www.excelforum.com/showthread.php?t=576315

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Target = "X"
End Sub

All i need help with now, is how i get this to work just in one column or a range of cells (eg A3:A20)?

Any help would be greatly appreciated!
Thanks

[davesexcel]

Try This

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Union(Range("$A$3:$A$20"), Target).Address = Range("$A$3:$A$20").Address Then
        Cancel = True
        If Target = "r" Then
            Target = ""
        Else
            With Target.Font
                .Name = "Webdings"
                .Size = 10
            End With
            Target = "r"
        End If
    End If
End Sub

Double click to get an X,
double click on an X to clear it

[Cheeba]

Thanks Davesexcel!
That works perfectly. Just what i was after.
If only everything in life could be sorted out so quickly!

Again, thanks!

[davesexcel]

Thanks Davesexcel!
That works perfectly. Just what i was after.
If only everything in life could be sorted out so quickly!

Again, thanks!

Thanks for the feed back,
I have always liked that way of creating "X" marks, if you change the code to "a" instead of "r" you will get a check mark