Check Mark , shortcut

[Chi Huynh]

Hi,
Following your respond, I can put check marks to cells.
However, I think there is a lot of typing.
Instead of holding down the ALT and type 0252 each time to
put a check mark to a cell,I would like to create a short
cut so I can finish my work quicklier.

Please show me how to create a shortcut.
Thank you
Chi

 

[Peo Sjoblom]

You only have to do it once, then copy it and paste it and if it is
contiguous just drag the
cell to copy
You can even record a macro when you do it and use a shortcut to run the
macro

 

[Jason Morin]

1. Press ALT+F11, click on Personal.xls, Insert > Module,
and paste this into the window:

Sub InsertCheck()
With Selection
.Formula = "ü"
.Font.Name = "Wingdings"
End With
End Sub

2. Now add a button with View > Toolbars > Customize >
Commands tab and scroll down to Macros. Drag the smiley
face to one of your toolbars.

3. Right-click on it and "Assign Macro" and
choose "InsertCheck" in personal.xls.

You can also easily change the button graphics (I'm using
XL2002). MVP David McRitchie has some instructions for
adding buttons and changing button graphic:

http://www.mvps.org/dmcritchie/excel/toolbars.htm

PS - don't forgot to save your personal.xls when closing
Excel.

HTH
Jason
Atlanta, GA

 

[Paul B]

Chi, here is one more way to do it

If you want to insert Check marks format your cells as Marlett then type the
letter "a".

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Bob Phillips]

Change the column font to Marlett, then all you need to get a checkmark is a
lower-case a.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

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


You can check to see if the cell is checked with something like this:

=if(a1="","not checked","Checked")

 

[David McRitchie]

I would format the column in the font you want for a
checkmark. You can choose your checkmark from
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm#ticks
and then use an event macro such as a double-click such as
http://www.mvps.org/dmcritchie/excel/event.htm#ticks

The example is set up for "wingdings 2" where a "P" is a checkmark.