I would like a simple check box which can be either checked or unchecked but
with no text values. I don't want it to say "true" or "false", just blank.
Can this be done? I'm using Excel 2000, and I'm a novice with this whole
check box thing.
Thank you.

In the properties for the check box, remove the linked cell value. This
should allow simply a check box with no referenced cell reporting a
True/False value.

-Chad

"Lisa" wrote:

I would like a simple check box which can be either checked or unchecked but
with no text values. I don't want it to say "true" or "false", just blank.
Can this be done? I'm using Excel 2000, and I'm a novice with this whole
check box thing.
Thank you.

That does work, however, I need this check box to be functional in a "shared"
workbook. The only way another user can check the box and check to remain is
when it is linked to a cell. More details....I've created a workbook that
will have a running check list that I need another user to check the boxes
when an item is received. But it just needs to be a simple check or no
check. Any advice?
Thanks.

"Chad" wrote:

In the properties for the check box, remove the linked cell value. This
should allow simply a check box with no referenced cell reporting a
True/False value.

-Chad

"Lisa" wrote:

I would like a simple check box which can be either checked or unchecked but
with no text values. I don't want it to say "true" or "false", just blank.
Can this be done? I'm using Excel 2000, and I'm a novice with this whole
check box thing.
Thank you.

Perhaps you could try leaving the linked cell in the workbook, but hide the
entire column of linked cells. For example, the linked cell for the first
checkbox is in cell d1 and the seond in d2, etc. Hide column D so the user
cannot see these values but the checkboxes maintain their checked or
unchecked value.

-Chad


"Lisa" wrote:

That does work, however, I need this check box to be functional in a "shared"
workbook. The only way another user can check the box and check to remain is
when it is linked to a cell. More details....I've created a workbook that
will have a running check list that I need another user to check the boxes
when an item is received. But it just needs to be a simple check or no
check. Any advice?
Thanks.

"Chad" wrote:

In the properties for the check box, remove the linked cell value. This
should allow simply a check box with no referenced cell reporting a
True/False value.

-Chad

"Lisa" wrote:

I would like a simple check box which can be either checked or unchecked but
with no text values. I don't want it to say "true" or "false", just blank.
Can this be done? I'm using Excel 2000, and I'm a novice with this whole
check box thing.
Thank you.

Is this still in the Shared workbook using checkboxes from the Forms toolbar?

If yes, you may want to share all the requirements in your post.

Lisa wrote:

I would like a simple check box which can be either checked or unchecked but
with no text values. I don't want it to say "true" or "false", just blank.
Can this be done? I'm using Excel 2000, and I'm a novice with this whole
check box thing.
Thank you.

--

Dave Peterson

Sorry Dave,
Yes, it's still with a shared workbook. Basically, I have a workbook that
will have a long list of names of files with check boxes. Once my other
worker receives this file she needs to go in and check the box to reflect
this. It's just a simple tracking system of file movement. So, I don't want
the true/false to show at all. I'm trying your last suggestion of linking to
cell below and then hiding that row, but honestly, the list will be quite
lengthy and this process is time consuming...but, gotta do what ya gotta do!

"Dave Peterson" wrote:

Is this still in the Shared workbook using checkboxes from the Forms toolbar?

If yes, you may want to share all the requirements in your post.

Lisa wrote:

I would like a simple check box which can be either checked or unchecked but
with no text values. I don't want it to say "true" or "false", just blank.
Can this be done? I'm using Excel 2000, and I'm a novice with this whole
check box thing.
Thank you.

--

Dave Peterson