Excellent solution, Dave! This works great! Thanks a million for this!

Now if the developers at Microsoft would make simple and common tasks like
this straightforward to begin with, we could actually do more work and less
figuring out how to make things work they way they're supposed to!

"Dave Peterson" wrote:

One more option:

Maybe just give the cell a custom format.

Format the cells by:
selecting them
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.

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")

You can just see if the cell is empty.

Arno Rite wrote:

I want a cell to be formatted as a checkbox. I don't want to use form or
activex controls. Is this doable?

--

Dave Peterson