I adjusted for my range (D3:D98) and clicked 5 boxes to make then show "X".
My formula cell now shows "FALSE". I need a count of the "X"s so that I can
figure a percentage of how many were checked out of a possible amount of
questions. Hope that makes sense....I know we are getting close. :)

"John" wrote:

Hi Cindy
If you're using the X : =COUNTIF(D1:D20,"=r")/COUNTA(D1:D20)
Adjust range to your needs.
HTH
John
"Cindy" wrote in message
...
This worked great! Can you tell me now how to make a formula that would add
up all the "x" marks in a single column and tell me the percentage of how
many were checked?

"Jacob Skaria" wrote:

Another workaround with fonts. Single click on any range to check/uncheck.

1. In the required range (suppose ColD) in all cells enter small letter "e".
2. Select all cells in that range and change the font to Marlett.
3. Adjust the column width to look like a square check box
4. Right click on the sheet tab and hit view code. Paste the below code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Font.Name = "Marlett" And Target.Count = 1 Then
Target.Value = IIf(Target.Value = "r", "e", "r")
'Target.Value = IIf(Target.Value = "a", "e", "a") 'For tick mark
End If
End Sub

Try single click on any of the cells in that range. To remove the check mark
click on another cell out of the range and again click on the cell.

If this post helps click Yes
---------------
Jacob Skaria


"8Gent'M'" wrote:

It would save me loads of time to be able to insert a check mark or other
symbol of my choosing into my Excel based calendar from a tool bar icon
instead of going thru the process of InsertSymbolselectinsertclose.
A simple icon that inserts my chosen symbol in the beginning of a cell to
mark that I have done that task.......Is this possible now or can I suggest
it?
Thanks for your time!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

.