ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   check box help (https://www.excelbanter.com/excel-discussion-misc-queries/82876-check-box-help.html)

Bman

check box help
 
I am putting two check boxes in a row, and when I check one box in each row I
want to be able to lock the other check boxes so there won't be able to be
multiple check boxes checked. Is there a forumula or some other way to
accomplish this??

Jim Rech

check box help
 
some other way to accomplish this??

In 'one or the other' situations option buttons are usually used rather than
check boxes. This is because selecting one automatically unselects the
other.


--
Jim
"Bman" wrote in message
...
|I am putting two check boxes in a row, and when I check one box in each row
I
| want to be able to lock the other check boxes so there won't be able to be
| multiple check boxes checked. Is there a forumula or some other way to
| accomplish this??



Bman

check box help
 
thank you very much!

"Jim Rech" wrote:

some other way to accomplish this??


In 'one or the other' situations option buttons are usually used rather than
check boxes. This is because selecting one automatically unselects the
other.


--
Jim
"Bman" wrote in message
...
|I am putting two check boxes in a row, and when I check one box in each row
I
| want to be able to lock the other check boxes so there won't be able to be
| multiple check boxes checked. Is there a forumula or some other way to
| accomplish this??





All times are GMT +1. The time now is 05:00 PM.

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