insert a checkmark

8

8Gent'M'

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 Insert>Symbol>select>insert>close.
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/com...c-1c731de05ef5&dg=microsoft.public.excel.misc
 
G

Gary''s Student

First enter this macro in a standard module:

Sub Macro1()
Selection.Font.Name = "Marlett"
Selection.Value = "b"
End Sub

and then assign it to either a toolbar button or a shortcut key.
 
J

Jacob Skaria

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
 
C

CTURNER82

This might be too simplistic, but I go through the insert process to put a
check mark in the first cell of the column, then when I need to mark a row
below I just right click to copy it and paste another one wherever I need it.
Have a great weekend!
 
C

Cindy

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?
 
J

John

Hi Cindy
If you're using the X : =COUNTIF(D1:D20,"=r")/COUNTA(D1:D20)
Adjust range to your needs.
HTH
John
 
C

Cindy

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. :)
 
D

Dave Peterson

Check your other post.
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?
 
J

John

Hi Cindy
You shouldn't multipost. Dave is giving you all the options on your other post.
=COUNTIF(D3:D98,"=r") will count how many X in that range.
=COUNTIF(D3:D98,"=r")/COUNTA(D3:D98) This should give you the percentage.
I don't really know why you're getting a "False" reading, did you double check
the formula,
I tested it and it work fine.
HTH
John
 
C

Cindy

John, I apologize to you and Dave both. I am just desperate for a
resolution. Maybe I should not have even used the code, but it made the
boxes look neat and worked really well for people to "X" the box.
Here is the formula I put in the cell at the bottom of column D:
=COUNTIF(D3:D98,"=r")/COUNTA(D3:D98). I am copying that from the Excel
program. Do you see a problem?

Am I suppossed to be putting it somewhere in the visual basic portion?
Again I am not meaning to offend anyone buy trying to get an answer.
Hopefully we can work it out on here. Thanks,
 
J

John

Hi Cindy
The formula goes in a cell anywhere but that range "D3:D98".
Am sorry but I can't figure why you are getting a "False" error.
=COUNTIF(D3:D98,"=r")/COUNTA(D3:D98). I am copying that from the Excel
program. Do you see a problem?
No, the = sign is redundant but works fine.
Did you try this formula just to count the "X" =COUNTIF(D3:D98,"=r")
Hope someone else can help
Sorry
John
 

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