Tick Mark

  • Thread starter Thread starter Bob Beard
  • Start date Start date
B

Bob Beard

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

Is there a shortcut key?

Thanks,

Bob.
 
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
 
Here is a example

Sub test()
With ActiveCell
.Font.Name = "Wingdings"
.FormulaR1C1 = "ü"
End With
End Sub
 
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.
 
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.)
 
Back
Top