ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel: creating a group of independent option buttons (https://www.excelbanter.com/excel-discussion-misc-queries/61555-excel-creating-group-independent-option-buttons.html)

tD

Excel: creating a group of independent option buttons
 
I'm trying to create two independant groups of buttons on a single page of an
Excel document. In other words, two cells, each with yes or no answers, each
having its own two option buttons. Right now, when I click "yes" in cell two,
it unchecks my answer in cell one. I just need to make the buttons in cell
two run independently of cell one.

Norman Jones

Excel: creating a group of independent option buttons
 
Hi tD,

Why not replace your option buttons with checkboxes?

---
Regards,
Norman



"tD" wrote in message
...
I'm trying to create two independant groups of buttons on a single page of
an
Excel document. In other words, two cells, each with yes or no answers,
each
having its own two option buttons. Right now, when I click "yes" in cell
two,
it unchecks my answer in cell one. I just need to make the buttons in
cell
two run independently of cell one.




Biff

Excel: creating a group of independent option buttons
 
Hi!

Are they option buttons from the Forms toolbar?

If so, then put each pair into it's own group box (also from the Forms
toolbar).

Biff

"tD" wrote in message
...
I'm trying to create two independant groups of buttons on a single page of
an
Excel document. In other words, two cells, each with yes or no answers,
each
having its own two option buttons. Right now, when I click "yes" in cell
two,
it unchecks my answer in cell one. I just need to make the buttons in
cell
two run independently of cell one.




tD

Excel: creating a group of independent option buttons
 
Problem solved with the group box... thank you, Biff.



"Biff" wrote:

Hi!

Are they option buttons from the Forms toolbar?

If so, then put each pair into it's own group box (also from the Forms
toolbar).

Biff

"tD" wrote in message
...
I'm trying to create two independant groups of buttons on a single page of
an
Excel document. In other words, two cells, each with yes or no answers,
each
having its own two option buttons. Right now, when I click "yes" in cell
two,
it unchecks my answer in cell one. I just need to make the buttons in
cell
two run independently of cell one.






All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com