Option Button

  • Thread starter Thread starter Robin Scott
  • Start date Start date
R

Robin Scott

1. I have added an option button. It is Surgery Yes (this option is numbered
23) or Surgery NO (this option is numbered 24).
2. B8 is the cell number.
3. I have formatted another cell with the formula =IF(B8=1,"Surgery
YES","Surgery NO") per the instructions of Microsoft.
4. However, even if I change to the number 23 or the number 24 following the
= sign, the anwer is always Surgery NO even if I toggle between both of the
selections.
5. I would appreciate your help concerning this issue. I am trying to make
the formula cause the answer to be the dotted option.
 
Hi,

Are you working on a user form in VBA or are you putting the option button
in the worksheet? Are these option buttons create using the Forms toolbar or
the Control Toolbox? What is it you want the button to do when you click it?
If its in the spreadsheet option buttons usually change the value in its
linked cell and that value is used in some manner. If in the spreadsheet are
there other option buttons on the same sheet? If they are, are they part of
the option buttons you are describing? Finally what do you mean by "dotted
option"?
 
1. I am putting the option button in the worksheet.

2. Next select the Developer Tab and in the controls group click on insert
and select option button from the forms control section

3. When a check mark is placed in the button that means that that is the
button to be selected and another cell to give the information that that is
the button that has been selected.

4. This is being done on a Excel Spreedsheet.

5. It only has 2 option buttons and they are of the numbers 23 for the 1st
one and 24 for the 2nd one.

6. Both option buttons are created in the same cell as per Microsoft
instructionsThe surgery Yes is the 1st button and the Surgery No.
In the cell underneath the previously stated cell there are
 
Robin Scott said:
1. I am putting the option button in the worksheet.

2. Next select the Developer Tab and in the controls group click on insert
and select option button from the forms control section

3. When a dot is placed in the button this means that is the
button to be selected. The cell below shows the selction that has been made.>
4. This is being done on a Excel Spreedsheet.

5. It only has 2 option buttons and they are of the numbers 23 for the 1st
one and 24 for the 2nd one.

6. Both option buttons are created in the same cell as per Microsoft
instructionsThe surgery Yes is the 1st button and the Surgery No. is the second option.
7. In the cell underneath the previously stated cell is where the words that go with the selected option button will be shown. The formula inserted in this cell is
Click to expand...
=IF(B8=1,"Surgery yes","Surgery NO") per the instructions of Microsoft.

*. This would imply if that the option button checked would show in the cell
underneath thecell of the with the option button selection.
8> When I spoke of a dotted option, I was trying to imply the option that
had been selected of the 2 options.

Sincerely,

Robin
 
Robin Scott said:
1. I am putting the option button in the worksheet.

2. Next select the Developer Tab and in the controls group click on insert
and select option button from the forms control section

3. When a check mark is placed in the button that means that that is the
button to be selected and another cell to give the information that that is
the button that has been selected.

4. This is being done on a Excel Spreedsheet.

5. It only has 2 option buttons and they are of the numbers 23 for the 1st
one and 24 for the 2nd one.

6. Both option buttons are created in the same cell as per Microsoft
instructionsThe surgery Yes is the 1st button and the Surgery No.
In the cell underneath the previously stated cell there are
Click to expand...
 
Hi,

I don't see what you are doing wrong so here are the steps from scratch.
1. Add two Option buttons to the spreadsheet, anywhere you want.
2. Right-click the text of the button and edit it to read something other
than Button 23, something like Surgery - Yes
3. Repeat step 2 for the other button but replace the button number with
Surgery - No. These two steps have no real effect on the way the buttons
work, its just nicer. You can enter any text you want.
4. Right click either button and choose Format Control, click the Control
tab, and enter B8 in the Cell link box, click OK. You only do this step for
one of the buttons, and it doesn't matter which one.
5. In another cell write formula
="Surgery "&IF(B8=1,"Yes","No")

If this helps click the Yes button.
 
Back
Top