Tick Mark

[Bob Beard]

Is there a way of putting a tick mark into a cell??

Is there a shortcut key?

Thanks,

Bob.

 

[Ron de Bruin]

Try this

No shortcut in Excel

1 : format the column with the Wingding font
2 : hold the Alt key, and type 0252 on the number keypad

You can make a macro and add a shortcut to it if you use it a lot
If you want that post back

 

[Ron de Bruin]

Here is a example

Sub test()
With ActiveCell
.Font.Name = "Wingdings"
.FormulaR1C1 = "ü"
End With
End Sub

 

[Bill]

Format to Wingdings 2 and enter a Capital P -

 

[Dave Peterson]

One more option:

Format the cell in "Wingdings 2"
but give it a custom format of P;P;P;P

Then any character(s) you type will make it look like a checkmark.

You could do the same with "wingdings"
and a custom format of: ü;ü;ü;ü
each ü is made by holding the altkey and typing 0252 from the number keypad.

 

[Dave Peterson]

Oops. I meant to add that when you want to see if that cell contains a
checkmark, just use:

=if(a1="","no check","has a checkmark")

(Since any value would make it look like a checkmark.)