You need to link the relevant controls and isolate them from the others. On the
Forms toolbar you will see what looks like a square with xyz at the top of it.
Click on that and drag a box around the controls you wish to group and these
will now operate independently of any other outside that box.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"stauff" wrote in message
...
For example

O Yes
O No

Next Cell

O Yes
O No

If i select the first Yes in the top cell and move to the next cell and
select No, then the top cell will clear and the bottom cell over rides it.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.784 / Virus Database: 530 - Release Date: 27/10/2004