Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS
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? -- Thanks, Pat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS
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. -- Please remember to indicate when the post is answered so others can benefit from it later. "Pat" wrote: 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? -- Thanks, Pat |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS
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 -- Thanks, Pat "KC Rippstein" wrote: 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. -- Please remember to indicate when the post is answered so others can benefit from it later. "Pat" wrote: 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? -- Thanks, Pat |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS
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. -- Please remember to indicate when the post is answered so others can benefit from it later. "Pat" wrote: 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 -- Thanks, Pat "KC Rippstein" wrote: 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. -- Please remember to indicate when the post is answered so others can benefit from it later. "Pat" wrote: 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? -- Thanks, Pat |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS
Thank you and your method does work. I will probably go that route.
-- Thanks, Pat "KC Rippstein" wrote: 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. -- Please remember to indicate when the post is answered so others can benefit from it later. "Pat" wrote: 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 -- Thanks, Pat "KC Rippstein" wrote: 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. -- Please remember to indicate when the post is answered so others can benefit from it later. "Pat" wrote: 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? -- Thanks, Pat |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS
Check your other post.
Pat wrote: 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? -- Thanks, Pat -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Cells Using Multiple Citeria | Excel Discussion (Misc queries) | |||
count cells using multiple criteria | Excel Worksheet Functions | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
Worksheet_Activate not working for multiple cells | Excel Discussion (Misc queries) | |||
Creating a single vertical array from multiple column arrays | Excel Worksheet Functions |