#1   Report Post  
Posted to microsoft.public.excel.misc
Bman
 
Posts: n/a
Default 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??
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default 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??


  #3   Report Post  
Posted to microsoft.public.excel.misc
Bman
 
Posts: n/a
Default 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??



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
... Can I set Spell Check to automatically check my spelling ... Dr. Darrell Setting up and Configuration of Excel 0 March 21st 06 08:26 PM
Entry into check box dependent on other check box. Stilla Excel Worksheet Functions 9 December 10th 05 03:44 PM
Can you sort with check boxes? Q Excel Discussion (Misc queries) 3 November 10th 05 08:11 PM
How do I use a check box to accept a calculation Joejoethecrackman Excel Discussion (Misc queries) 5 March 22nd 05 08:47 PM
Creating a check box that does not require security clearance. Maverick2U Excel Worksheet Functions 6 December 14th 04 02:46 AM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"