Insert a 'tick' symbol???

  • Thread starter Thread starter ian123
  • Start date Start date
I

ian123

Does anyone know an easy way to insert a tick into a cell?

Ideally i don't want to use an image, bitmap, gif or whatever - is
there an easier way?

I usually work with Times New Roman or Ariel font and would like to
operate with this if possible.


Many thanks
 
If "tick" = "check mark", then what you can do is hold
down the ALT key and type 0252 on your numeric keypad.
Then format as Wingdings. Or, you can also create a
toolbar icon that automatically inserts check marks when
you click it. For details on this, see:

http://makeashorterlink.com/?H27614D27

HTH
Jason
Atlanta, GA
 
thanks for the help, unfortunately its not quite working for me. i am
getting a symbol but not the tick/check mark desired.

I am using excel 2000 - does this affect the number to be input, ie
instead of 0252 should i be using a differentfigure?

many thanks
 
Possibly you have the wrong font like if you see "u" with an umlaut
(ü), or didn't actually type the code correctly, you can check the
code with =CODE(A1) and you can check the font in the font box.

There are others that are easier to enter than using the Wingdings font.
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
If you use "Wingdings 2" font then you can type a capital P.
 
Hi Ian!

Did you use Wingdings?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks everyone for your help, have got it working as i wanted now.

For those interested i used Davids advice of using capital P i
Wingdings 2 font and then added it to a custom button per th
'makeashorterlink' info from Jason.

Thanks guys
 
Hi Ian,
To use an icon, you wouldn't you have to select the cell and then
click on the toolbar icon ?

If you are using the mouse, you can use an Event macro to
simply double-click on the cell as show in
http://www.mvps.org/dmcritchie/excel/event.htm#ticks

If just using the keyboard you could use a change event macro
to make anything typed in that is not empty or a space convert to
a capital "P" otherwise have the cell cleared out.
Pre format the column (column 1 used in example) as "wingdings 2"

Private Sub Worksheet_Change(ByVal Target As Range)
'to install -- right-click on the sheettab of the sheet to
' be used in and choose 'view code'. Paste this Worksheet
' event macro into the module.
'-- Column A should be preformatted as "wingdings 2"
If Target.Column <> 1 Then Exit Sub 'check for Column A
If Target.Row = 1 Then Exit Sub
Application.EnableEvents = False
If Trim(Target.Value) <> "" Then
Target.Value = "P"
Else
Target.Formula = "" 'clear out cell
End If
Application.EnableEvents = True
End Sub
 
Back
Top