Insert a 'tick' symbol???

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
 
J

Jason Morin

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
 
I

ian123

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
 
D

David McRitchie

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.
 
N

Norman Harker

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.
 
I

ian123

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
 
D

David McRitchie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top