I am sharing with you very interesting trick to insert check mark symbols / to change check mark symbols with the double click in excel.
We can use Wingding font check boxes and change them with the double click with the help of macro
You can add as many of them by just defining the range in your macro. Values can be changed by just a double click.
You will further need to do data validation for that range so that user does not enter any other value by mistake.
You will need to
copy this code to worksheet module of your workbook
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'*************************************************************************************************************************
'* Macro recorded by Yogesh Gupta, smiley123z@gmail.com, Ygblogs.blogspot.com on September 16, 2009 *
'*************************************************************************************************************************
If Not Intersect(Target, Range("G4:G14")) Is Nothing Then ' You can Change the range here
Cancel = True
With Target
.Font.Name = "Wingdings"
.Font.Size = 20
.HorizontalAlignment = xlCenter
End With
If Target.Value = "þ" Then
Target.Value = "ý"
Else
Target.Value = "þ"
End If
End If
End Sub
|
Download file having trick to insert /change wingdings check mark symbols with double click
Make sure that you have enabled macros before using this file.
This trick can be used to choose any values you want change with the double click and is not limited only to check boxes in wingdings. See the attached file for Yes/No as another example.
Symbol Check Mark , Symbols Check Mark , Type Check Mark , Wingding Font Check Mark , Wingding Check Mark , Wingdings Check Mark , Check Mark Symbol , Check Mark Symbols , Check Symbol , Change values with double click in excel
