Need help with the simplest thing with the check box

  • Thread starter Thread starter Zubbus
  • Start date Start date
Z

Zubbus

I'm trying to do the simplest thing (and have wanted to for years) wit
a check box - stick it -in- a cell just so I can check or uncheck it
Of course, it will be even better if I can get the rest of th
worksheet to read a 1/0 or true/false from this box; but I'm usin
office 2000 and it says nothing useful. I pull the box out of the for
toolbar, but it's a floating object like a chart. And that's all th
reference I can find in Officer 2000.

Thanks in advance for any help you can give
 
"....but it's a floating object like a chart. And that's all the
reference I can find in Officer 2000....."
Whats floating?
the tool bar or the checkbox?
if you are using the forms toolbar, click on the checkbox and then go
to the range you want the checkbox ,left click on the mouse and draw in
the checkbox
once you have done that right click on the checkbox and select format
control, select control and then cell link, the cell link will display
a true or false whenever the check box is clicked, right click on the
checkbox again and edit the text
 
But how do I put it <i>in</i> a cell, so I can just do the usual drag
and stuff, and there will already be a value in the cell it's sitting
in?
 
Zubbus said:
But how do I put it <i>in</i> a cell, so I can just do the usual drag
and stuff, and there will already be a value in the cell it's sitting
in?[/QUOTe
go back to format control and select 3d shading, then delete all the
text from the checkbox, the checkbox and a value will fit in one cell
now!
Click to expand...
 
I already knew all the things you said (and have no idea why you brought
up 3D shading). Just didn't want to hurt your feelings (which you last
post suggests to be kinda fragile).

Sometimes, when a person with the answers sees there's already lots of
replies, he won't bother checking in, so you're kinda in the way
here...
 
You already got answers when you posted this question the first time

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
And I received e-mail notifications for those replies.
Except that I deleted that thread before they finished answering, so
can't see what they said. Bad move, but too late to do anything abou
that now
 
Here's the one from Dave Peterson

"You can still use that checkbox from the Forms toolbar.

Right click on it and choose "format control"
Then on the control tab, use the cell link.

Then you can use that cell in your formulas--it'll show true or false.

If you have lots of these checkboxes, you can put all the linked cells in a
column and hide that column.

Or you could format those cells with a custom format of:
;;;
(3 semicolons)
and the cell will look empty--but you can still see the value in the formula
bar
(and use it in other formulas)"

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Pretty much the same thing dave said. So I take it I *can't* have them
the way they are like in dataview in Access (which is another way of
putting what I was asking).
Ah yes, something mentioned these posts are duplicated in Google
groups. Didn't think about that.

Ah well, thanks all.
 
Back
Top