adding multiple checkboxes in a single cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add 2 checkboxes in one cell, similar to a yes/no checkbox but name
one contract and one permanent so that the person entering the data chooses
either or in that cell in order to identify if an employee is a permanent
employee or not. Can this be done in excel?
 
Not really, not the way I think you mean. But remember that one box has two
conditions: checked and not checked. So you could simply put one box in the
cell and set it up so that Checked means Permanent Employee and unchecked
means not permanent employee (contractor/temp/etc).

Get a checkbox, either from the Controls Toolbox or (I prefer) the Forms
toolbox (View | Toolbars to select one or the other of them) and in the
properties for the control, you can set a Cell Link - that cell will reflect
the status of the check box. Then it's easy to check the value in that cell
to see if the person is an employee or not - the values would be TRUE for is
employee, FALSE for is not.

Trick: place the checkbox right on top of the cell that you make the linked
cell then set the cell's font color to the same as the background color and
you won't see the TRUE/FALSE words in the cell, but they'll still be there
for examination and testing. You'll just see the checkbox itself (you can
empty out the text that goes with the label for it).

I hope you find that this is at least a little helpful in your search for a
solution.
 
Back
Top