CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS

[Guest]

I would like 2 checkboxes in one cell similar to a yes/no checkbox but with
different corresponding names such as: one checkbox called contract the
other permanent so that the person entering info. chooses one which
identifies an employee as either contract or permanent. Can this be done in
excel?

 

[Guest]

The best way to do this is use a data validation drop down box. I am going
to assume your checkboxes are going in cell B2.

Off in cell AA1, put the word "Contract" without quotes and in AA2 put the
word "Permanent". Then in B2, go to Data->Validation and in the first drop
down box (called "Allow:") select "List". Uncheck the "Ignore Blanks"
checkbox so that a value has to be entered, then in the "Source:" field type
this formula:
=$AA$1:$AA$2
Now when someone goes to that cell, they are forced to select Contract or
Permanent from the drop down list and it will not take any other answer and
will not allow them to just leave it blank.

Your checkboxes idea gets a little more complicated because you have to have
restrictions that one (and only one) box must be checked. If you absolutely
must go this way, post back here that you must do it that way, but hopefully
the answer above gets you there as it is much easier.

 

[Guest]

Thank you so much, this method worked. Is there anyway of showing both
contract and permanent in the cell with a box beside each so that one or the
other is checked off

 

[Guest]

I'm fairly certain you would have to use a worksheet change event macro that
detects when one of the boxes is checked and forces the other box to be
unchecked. I don't personally know the best way to do that macro, so I was
hoping you could do this just using the formulas I suggested.

 

[Guest]

Thank you and your method does work. I will probably go that route.

 

[Dave Peterson]

Check your other post.

I would like 2 checkboxes in one cell similar to a yes/no checkbox but with
different corresponding names such as: one checkbox called contract the
other permanent so that the person entering info. chooses one which
identifies an employee as either contract or permanent. Can this be done in
excel?