Check box in excel

[5pds]

Hi there

how easy is it to add a check box to a spreadsheet to only show the tick.

when i add a box, the tick doesnt appear.

i do not want to assign a macro to this, only want to show a tick in the box.

Please help

regards

paul

 

[lenze]

Use a simulated Check Box. The below will toggle the cells in Column "B" between a check and a blank when the cell is DoubleClicked

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column <> 2 Then Exit Sub
Target.Font.Name = "marlett"
If Target <> "a" Then
    Target = "a"
Else: Target = ""
End If
End Sub

See my article at VBAExpress
http://www.vbaexpress.com/kb/getarticle.php?kb_id=879

lenze