Adding an "X" or Check to a cell by clicking on the mouse

Good morning,

I am attempting to create a spreadsheet within Excel 2003. I have partially
completed it and would like to have it so that when I click on the boxes an
"X" or a check mark appears. I have tried adding the check box but that is
not quite what I want (not that I've fully figured it out). I want the "X"
or check mark to fill the space with no wording. Can this be done...I am
pretty Excel illiterate and not the best with computers in general so I need
all the help that I can get.

Also, my list is very long and has headings in the first 2 rows that I need
to see when I get to the bottom so that I know which type and size boxes to
check. I have tried playing with the zoom button but to be able to see at
the bottom of the page I have to take it down to 25% and I am old and would
need a magnifying glass to see it...LOL

Any help would be very much appreciated!!

THANK YOU!!!!!!!! (-:

A 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


"KAZ" wrote:

Good morning,

I am attempting to create a spreadsheet within Excel 2003. I have partially
completed it and would like to have it so that when I click on the boxes an
"X" or a check mark appears. I have tried adding the check box but that is
not quite what I want (not that I've fully figured it out). I want the "X"
or check mark to fill the space with no wording. Can this be done...I am
pretty Excel illiterate and not the best with computers in general so I need
all the help that I can get.

Also, my list is very long and has headings in the first 2 rows that I need
to see when I get to the bottom so that I know which type and size boxes to
check. I have tried playing with the zoom button but to be able to see at
the bottom of the page I have to take it down to 25% and I am old and would
need a magnifying glass to see it...LOL

Any help would be very much appreciated!!

THANK YOU!!!!!!!! (-:

Double-click is very easy.

Install the following event macro in the worksheet code area:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Value = "X"
End Sub

Once installed, a double-click on a cell will place an X in it.


Because it is worksheet code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

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

To learn more about Event Macros (worksheet code), see:

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


--
Gary''s Student - gsnu200908


"KAZ" wrote:

Good morning,

I am attempting to create a spreadsheet within Excel 2003. I have partially
completed it and would like to have it so that when I click on the boxes an
"X" or a check mark appears. I have tried adding the check box but that is
not quite what I want (not that I've fully figured it out). I want the "X"
or check mark to fill the space with no wording. Can this be done...I am
pretty Excel illiterate and not the best with computers in general so I need
all the help that I can get.

Also, my list is very long and has headings in the first 2 rows that I need
to see when I get to the bottom so that I know which type and size boxes to
check. I have tried playing with the zoom button but to be able to see at
the bottom of the page I have to take it down to 25% and I am old and would
need a magnifying glass to see it...LOL

Any help would be very much appreciated!!

THANK YOU!!!!!!!! (-:

Without using a checkbox form (which it sounds like you don't want to use)
you will need to somehow enter the data into a cell. However, if you want to
just use the mouse, there are options.

Select the cells that you want to place the marks into. Under Data -
Validation, select List from the first box. In the input box, enter your
character (in this case, X)
Ok out.

Now, click on your cell, click on dropdown, and you can place an X into the
cell.
Alternate: If you want a checkmark (in appearance) format the cell to have a
font of Wingdings 2, and use P as your character.


Your latter question is much easier. W/o playing with the zoom feature,
select row 3. Then, goto Window - freeze pane. Voila!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"KAZ" wrote:

Good morning,

I am attempting to create a spreadsheet within Excel 2003. I have partially
completed it and would like to have it so that when I click on the boxes an
"X" or a check mark appears. I have tried adding the check box but that is
not quite what I want (not that I've fully figured it out). I want the "X"
or check mark to fill the space with no wording. Can this be done...I am
pretty Excel illiterate and not the best with computers in general so I need
all the help that I can get.

Also, my list is very long and has headings in the first 2 rows that I need
to see when I get to the bottom so that I know which type and size boxes to
check. I have tried playing with the zoom button but to be able to see at
the bottom of the page I have to take it down to 25% and I am old and would
need a magnifying glass to see it...LOL

Any help would be very much appreciated!!

THANK YOU!!!!!!!! (-:

How about another alternative...

(saved from a previous post)

Select the range that would have held the checkboxes.
Format|cells|number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252

But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.

It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings (make it as large as you want)

Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
mark.

Hit the delete key on the keyboard to clear the cell.

If you have to use that "checkmark" in later formulas:
=if(a1="","no checkmark","Yes checkmark")
or
=counta(a1:a10)
to get the number of "checked" cells in A1:A10

Or you can filter by blanks and non-blanks.

KAZ wrote:

Good morning,

I am attempting to create a spreadsheet within Excel 2003. I have partially
completed it and would like to have it so that when I click on the boxes an
"X" or a check mark appears. I have tried adding the check box but that is
not quite what I want (not that I've fully figured it out). I want the "X"
or check mark to fill the space with no wording. Can this be done...I am
pretty Excel illiterate and not the best with computers in general so I need
all the help that I can get.

Also, my list is very long and has headings in the first 2 rows that I need
to see when I get to the bottom so that I know which type and size boxes to
check. I have tried playing with the zoom button but to be able to see at
the bottom of the page I have to take it down to 25% and I am old and would
need a magnifying glass to see it...LOL

Any help would be very much appreciated!!

THANK YOU!!!!!!!! (-:

--

Dave Peterson