Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. "Pat" wrote: 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? -- Thanks, Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple cell values to be drawn from single cell/id. | Excel Discussion (Misc queries) | |||
Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
Can multiple cell results be displayed in a single cell? | Excel Discussion (Misc queries) | |||
Toggle multiple values in single cell | Excel Worksheet Functions | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) |