How to make a tick box

B

blommerse

In my sheet I have multiple boxes. I want when I click them a V (check
mark) appears in it.
Should I do this with a code? or macro?

Thanks for help!

Regards,
Berry
 
B

Bob Phillips

This works by double-clicking in a cell, and toggles the check-mark.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Const WS_RANGE As String = "H1:H10" '<=== change to suit

On Error GoTo err_handler
Application.EnableEvents = False
If Not Application.Intersect(Target, Range(WS_RANGE)) Is Nothing Then
With Target
.Font.Name = "Marlett"
Select Case .Value
Case "": .Value = "a"
Case "a": .Value = ""
End Select
End With
End If
err_handler:
Application.EnableEvents = True
End Sub


'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

blommerse

Thanks Bob for your code. Unfortunatelly it did not worked. I get a
error. Maybe you can send me a empty sheet with your code in it.
My email is [email protected]

Thank you
 
B

blommerse

Thanks Bob for your code. Unfortunatelly it did not worked. I get a
error. Maybe you can send me a empty sheet with your code in it.
My email is [email protected]

Thank you
 
Top